Product: | WIP - Work in Process |
---|---|
Description: | Foreign-key data for WIP_MOVE_TRANSACTIONS |
Implementation/DBA Data: | APPS.WIP_MOVE_TRANSACTIONS_V |
SELECT WMT.ROWID ROW_ID
, WMT.TRANSACTION_ID
, WMT.LAST_UPDATE_DATE
, WMT.LAST_UPDATED_BY
, WMT.CREATION_DATE
, WMT.CREATED_BY
, WMT.LAST_UPDATE_LOGIN
, WMT.REQUEST_ID
, WMT.PROGRAM_APPLICATION_ID
, WMT.PROGRAM_ID
, WMT.PROGRAM_UPDATE_DATE
, WMT.GROUP_ID
, WMT.SOURCE_CODE
, WMT.SOURCE_LINE_ID
, WMT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HAOU.NAME ORGANIZATION_NAME
, WMT.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WMT.LINE_ID
, WL.LINE_CODE
, WMT.PRIMARY_ITEM_ID
, WMT.TRANSACTION_DATE
, WMT.ACCT_PERIOD_ID
, WMT.FM_OPERATION_SEQ_NUM
, WMT.FM_OPERATION_CODE
, WMT.FM_DEPARTMENT_ID
, BD1.DEPARTMENT_CODE FM_DEPARTMENT_CODE
, WMT.FM_INTRAOPERATION_STEP_TYPE
, ML1.MEANING FM_INTRAOPERATION_STEP_MEANING
, WMT.TO_OPERATION_SEQ_NUM
, WMT.TO_OPERATION_CODE
, WMT.TO_DEPARTMENT_ID
, BD2.DEPARTMENT_CODE TO_DEPARTMENT_CODE
, WMT.TO_INTRAOPERATION_STEP_TYPE
, ML2.MEANING TO_INTRAOPERATION_STEP_MEANING
, WMT.TRANSACTION_QUANTITY
, WMT.TRANSACTION_UOM
, WMT.PRIMARY_QUANTITY
, WMT.PRIMARY_UOM
, WMT.SCRAP_ACCOUNT_ID
, WMT.REASON_ID
, MTR.REASON_NAME
, WMT.REFERENCE
, WMT.QA_COLLECTION_ID
, WMT.ATTRIBUTE_CATEGORY
, WMT.ATTRIBUTE1
, WMT.ATTRIBUTE2
, WMT.ATTRIBUTE3
, WMT.ATTRIBUTE4
, WMT.ATTRIBUTE5
, WMT.ATTRIBUTE6
, WMT.ATTRIBUTE7
, WMT.ATTRIBUTE8
, WMT.ATTRIBUTE9
, WMT.ATTRIBUTE10
, WMT.ATTRIBUTE11
, WMT.ATTRIBUTE12
, WMT.ATTRIBUTE13
, WMT.ATTRIBUTE14
, WMT.ATTRIBUTE15
, WMT.OVERCOMPLETION_TRANSACTION_QTY
, WMT.OVERCOMPLETION_PRIMARY_QTY
, WMT.OVERCOMPLETION_TRANSACTION_ID
, WMT.EMPLOYEE_ID
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MTL_TRANSACTION_REASONS MTR
, BOM_DEPARTMENTS BD1
, BOM_DEPARTMENTS BD2
, WIP_ENTITIES WE
, WIP_LINES WL
, WIP_MOVE_TRANSACTIONS WMT
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE WMT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WMT.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WMT.LINE_ID = WL.LINE_ID (+)
AND WMT.ORGANIZATION_ID = WL.ORGANIZATION_ID (+)
AND WMT.FM_DEPARTMENT_ID = BD1.DEPARTMENT_ID
AND ML1.LOOKUP_CODE = WMT.FM_INTRAOPERATION_STEP_TYPE
AND ML1.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND WMT.TO_DEPARTMENT_ID = BD2.DEPARTMENT_ID
AND ML2.LOOKUP_CODE = WMT.TO_INTRAOPERATION_STEP_TYPE
AND ML2.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND WMT.REASON_ID = MTR.REASON_ID (+)
AND WMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WMT.ORGANIZATION_ID = HAOU.ORGANIZATION_ID