Product: | WIP - Work in Process |
---|---|
Description: | Foreign-key data WIP_MOVE_TXN_INTERFACE |
Implementation/DBA Data: | APPS.WIP_MOVE_TXN_INTERFACE_V |
SELECT WMTI.ROWID ROW_ID
, WMTI.TRANSACTION_ID
, WMTI.LAST_UPDATE_DATE
, WMTI.LAST_UPDATED_BY
, WMTI.LAST_UPDATED_BY_NAME
, WMTI.CREATION_DATE
, WMTI.CREATED_BY
, WMTI.CREATED_BY_NAME
, WMTI.LAST_UPDATE_LOGIN
, WMTI.REQUEST_ID
, WMTI.PROGRAM_APPLICATION_ID
, WMTI.PROGRAM_ID
, WMTI.PROGRAM_UPDATE_DATE
, WMTI.GROUP_ID
, WMTI.SOURCE_CODE
, WMTI.SOURCE_LINE_ID
, WMTI.PROCESS_PHASE
, ML4.MEANING PROCESS_PHASE_MEANING
, WMTI.PROCESS_STATUS
, ML5.MEANING PROCESS_STATUS_MEANING
, WMTI.ORGANIZATION_ID
, WMTI.ORGANIZATION_CODE
, WMTI.WIP_ENTITY_ID
, WMTI.WIP_ENTITY_NAME
, WMTI.ENTITY_TYPE
, WMTI.PRIMARY_ITEM_ID
, WMTI.LINE_ID
, WMTI.LINE_CODE
, WMTI.REPETITIVE_SCHEDULE_ID
, WMTI.TRANSACTION_DATE
, WMTI.ACCT_PERIOD_ID
, WMTI.FM_OPERATION_SEQ_NUM
, WMTI.FM_OPERATION_CODE
, WMTI.FM_DEPARTMENT_ID
, WMTI.FM_DEPARTMENT_CODE
, WMTI.FM_INTRAOPERATION_STEP_TYPE
, ML.MEANING FM_INTRAOPERATION_STEP_MEANING
, WMTI.TO_OPERATION_SEQ_NUM
, WMTI.TO_OPERATION_CODE
, WMTI.TO_DEPARTMENT_ID
, WMTI.TO_DEPARTMENT_CODE
, WMTI.TO_INTRAOPERATION_STEP_TYPE
, ML2.MEANING TO_INTRAOPERATION_STEP_MEANING
, WMTI.TRANSACTION_QUANTITY
, WMTI.TRANSACTION_UOM
, WMTI.PRIMARY_QUANTITY
, WMTI.PRIMARY_UOM
, WMTI.SCRAP_ACCOUNT_ID
, WMTI.REASON_ID
, WMTI.REASON_NAME
, WMTI.REFERENCE
, WMTI.QA_COLLECTION_ID
, WMTI.ATTRIBUTE_CATEGORY
, WMTI.ATTRIBUTE1
, WMTI.ATTRIBUTE2
, WMTI.ATTRIBUTE3
, WMTI.ATTRIBUTE4
, WMTI.ATTRIBUTE5
, WMTI.ATTRIBUTE6
, WMTI.ATTRIBUTE7
, WMTI.ATTRIBUTE8
, WMTI.ATTRIBUTE9
, WMTI.ATTRIBUTE10
, WMTI.ATTRIBUTE11
, WMTI.ATTRIBUTE12
, WMTI.ATTRIBUTE13
, WMTI.ATTRIBUTE14
, WMTI.ATTRIBUTE15
, WMTI.TRANSACTION_TYPE
, ML3.MEANING TRANSACTION_TYPE_MEANING
, WMTI.OVERCOMPLETION_TRANSACTION_QTY
FROM MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, WIP_MOVE_TXN_INTERFACE WMTI
WHERE ML.LOOKUP_TYPE (+) = 'WIP_INTRAOPERATION_STEP'
AND ML.LOOKUP_CODE (+) = WMTI.FM_INTRAOPERATION_STEP_TYPE
AND ML2.LOOKUP_TYPE (+) = 'WIP_INTRAOPERATION_STEP'
AND ML2.LOOKUP_CODE (+) = WMTI.TO_INTRAOPERATION_STEP_TYPE
AND ML3.LOOKUP_TYPE (+) = 'WIP_MOVE_TRANSACTION_TYPE'
AND ML3.LOOKUP_CODE (+) = WMTI.TRANSACTION_TYPE
AND ML4.LOOKUP_TYPE = 'WIP_MOVE_PROCESS_PHASE'
AND ML4.LOOKUP_CODE = WMTI.PROCESS_PHASE
AND ML5.LOOKUP_TYPE = 'WIP_PROCESS_STATUS'
AND ML5.LOOKUP_CODE = WMTI.PROCESS_STATUS