VIEW: APPS.WSM_SERIAL_MOVE_GENEALOGY_V

Source

View Text - Preformatted

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 ,WSMT.GEN_OBJECT_ID OBJECT_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 , WIP_SERIAL_MOVE_TRANSACTIONS WSMT WHERE WMT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND WMT.ORGANIZATION_ID = WE.ORGANIZATION_ID AND WMT.LINE_ID = WL.LINE_ID (+) AND WSMT.TRANSACTION_ID = WMT.TRANSACTION_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

View Text - HTML Formatted

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
, WSMT.GEN_OBJECT_ID OBJECT_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
, WIP_SERIAL_MOVE_TRANSACTIONS WSMT
WHERE WMT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WMT.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND WMT.LINE_ID = WL.LINE_ID (+)
AND WSMT.TRANSACTION_ID = WMT.TRANSACTION_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