RCS_ITEM_UOM_CONVERSIONS_V
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: VIEW
Columns
Name |
---|
ITEM_UOM_CONV_ID INVENTORY_ITEM_ID TRANSACTION_UOM_CODE PRIMARY_UOM_CODE CONVERSION_RATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER |
Query
SQL_Statement |
---|
SELECT item_uom_conv_id, inventory_item_id, transaction_uom_code, primary_uom_code, conversion_rate, created_by, creation_date, last_update_date, last_update_login, last_updated_by, object_version_number FROM rcs_item_uom_conversions UNION SELECT txnuom.conversion_id, items.inventory_item_id inventory_item_id, txnuom.uom_code transaction_uom_code, items.primary_uom_code primary_uom_code, DECODE(items.primary_uom_code,txnuom.uom_code,1,inv_convert.inv_um_convert_no_precision(items.inventory_item_id,1,txnuom.uom_code,items.primary_uom_code ,NULL,NULL) ) conversion_rate, txnuom.created_by, txnuom.creation_date, txnuom.last_update_date, txnuom.last_update_login, txnuom.last_updated_by, txnuom.object_version_number FROM ( SELECT inventory_item_id, primary_uom_code FROM egp_item_primary_uoms_v egp WHERE egp.primary_uom_code IS NOT NULL AND NOT EXISTS ( SELECT 1 FROM inv_uom_conversions WHERE egp.inventory_item_id = inventory_item_id UNION SELECT 1 FROM inv_uom_class_conversions WHERE egp.inventory_item_id = inventory_item_id ) ) items, inv_units_of_measure_b uoms, inv_uom_conversions txnuom WHERE items.primary_uom_code = uoms.uom_code AND txnuom.uom_class = uoms.uom_class AND uoms.DERIVED_UNIT_PARENT_CODE IS NULL AND txnuom.inventory_item_id = 0 |