View: EAM_CFR_ISSUED_SERIALS_V

Product:	EAM - Enterprise Asset Management
Description:	Work Order Completion Issued Serials
Implementation/DBA Data:	APPS.EAM_CFR_ISSUED_SERIALS_V

View Text

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'

Columns