View: EAM_CFR_WORK_COMPLETION_V

Product:	EAM - Enterprise Asset Management
Description:	This view displays the details of all maintenance work orders completed or uncompleted .This view is used for ERES at the time of work order completion in the XGM.
Implementation/DBA Data:	APPS.EAM_CFR_WORK_COMPLETION_V

View Text

SELECT EJCT.TRANSACTION_ID
, EJCT.TRANSACTION_TYPE
, ML1.MEANING TRANSACTION_NAME
, EJCT.TRANSACTION_DATE
, EJCT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, EJCT.WIP_ENTITY_ID
, EJCT.ACTUAL_START_DATE
, EJCT.ACTUAL_DURATION
, EJCT.ACTUAL_END_DATE
, ML2.MEANING RECONCILIATION_CODE
, EJCT.COMPLETION_SUBINVENTORY
, EJCT.COMPLETION_LOCATOR_ID
, MILK.CONCATENATED_SEGMENTS
, EJCT.LOT_NUMBER
FROM EAM_JOB_COMPLETION_TXNS EJCT
, MTL_PARAMETERS MP
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MTL_ITEM_LOCATIONS_KFV MILK
WHERE EJCT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND EJCT.TRANSACTION_TYPE = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'EAM_JOB_TXN_TYPE'
AND EJCT.RECONCILIATION_CODE = ML2.LOOKUP_CODE (+)
AND ML2.LOOKUP_TYPE (+) = 'WIP_EAM_RECONCILIATION_CODE'
AND EJCT.COMPLETION_LOCATOR_ID = MILK.INVENTORY_LOCATION_ID (+)
AND EJCT.ORGANIZATION_ID = MILK.ORGANIZATION_ID (+)

Columns