VIEW: APPS.WIP_MOVE_TXN_INTERFACE_V

Source

View Text - Preformatted

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 , WMTI.COMPLETED_INSTRUCTIONS 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

View Text - HTML Formatted

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
, WMTI.COMPLETED_INSTRUCTIONS
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