VIEW: APPS.EAM_CFR_WORK_COMPLETION_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)