VIEW: APPS.EAM_CFR_ISSUED_SERIALS_V

Source

View Text - Preformatted

SELECT CII.INSTANCE_ID, CII.INSTANCE_NUMBER, CII.SERIAL_NUMBER, CII.INSTANCE_DESCRIPTION, MUT.INVENTORY_ITEM_ID, MSI.CONCATENATED_SEGMENTS, MSI.DESCRIPTION, MUT.TRANSACTION_SOURCE_ID AS WIP_ENTITY_ID, MUT.ORGANIZATION_ID, EC.METER_ID, EC.METER_NAME, EC.SOURCE_METER_ID, EC.SOURCE_METER_NAME FROM MTL_UNIT_TRANSACTIONS MUT, CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS_KFV MSI, EAM_COUNTERS_V EC, CSI_COUNTER_ASSOCIATIONS CCA WHERE MUT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MUT.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MUT.SERIAL_NUMBER = CII.SERIAL_NUMBER AND MUT.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID AND MUT.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID AND MUT.TRANSACTION_SOURCE_TYPE_ID = 5 AND CCA.SOURCE_OBJECT_ID (+) = CII.INSTANCE_ID AND SYSDATE BETWEEN NVL(CCA.START_DATE_ACTIVE, SYSDATE-1) AND NVL(CCA.END_DATE_ACTIVE, SYSDATE+1) AND CCA.COUNTER_ID = EC.METER_ID (+) AND EC.TMPL_FLAG (+) = 'N'

View Text - HTML Formatted

SELECT CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.SERIAL_NUMBER
, CII.INSTANCE_DESCRIPTION
, MUT.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MUT.TRANSACTION_SOURCE_ID AS WIP_ENTITY_ID
, MUT.ORGANIZATION_ID
, EC.METER_ID
, EC.METER_NAME
, EC.SOURCE_METER_ID
, EC.SOURCE_METER_NAME
FROM MTL_UNIT_TRANSACTIONS MUT
, CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_KFV MSI
, EAM_COUNTERS_V EC
, CSI_COUNTER_ASSOCIATIONS CCA
WHERE MUT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MUT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MUT.SERIAL_NUMBER = CII.SERIAL_NUMBER
AND MUT.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MUT.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND MUT.TRANSACTION_SOURCE_TYPE_ID = 5
AND CCA.SOURCE_OBJECT_ID (+) = CII.INSTANCE_ID
AND SYSDATE BETWEEN NVL(CCA.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(CCA.END_DATE_ACTIVE
, SYSDATE+1)
AND CCA.COUNTER_ID = EC.METER_ID (+)
AND EC.TMPL_FLAG (+) = 'N'