VIEW: APPS.INVFV_MOVE_ORDERS_LINES

Source

View Text - Preformatted

SELECT TRL.LINE_ID , TRL.HEADER_ID , TRH.REQUEST_NUMBER , TRL.LINE_NUMBER , MTT.TRANSACTION_TYPE_NAME , MST.TRANSACTION_SOURCE_TYPE_NAME , TRL.ORGANIZATION_ID , HOU.NAME , TRL.INVENTORY_ITEM_ID , '_KF:INV:MSTK:MSI' , TRL.REVISION , TRL.FROM_SUBINVENTORY_ID , TRL.FROM_SUBINVENTORY_CODE , TRL.FROM_LOCATOR_ID , '_KF:INV:MTLL:MIL' , TRL.TO_SUBINVENTORY_CODE , TRL.TO_SUBINVENTORY_ID , TRL.TO_LOCATOR_ID , '_KF:INV:MTLL:MIT' , TRL.TO_ACCOUNT_ID , '_KF:SQLGL:GL#:GLC' , TRL.LOT_NUMBER , TRL.SERIAL_NUMBER_START , TRL.SERIAL_NUMBER_END , TRL.UOM_CODE , TRL.QUANTITY , TRL.QUANTITY_DELIVERED , TRL.QUANTITY_DETAILED , TRL.DATE_REQUIRED , TRL.REASON_ID , MTR.REASON_NAME , '_LA:TRL.REFERENCE_TYPE_CODE:MFG_LOOKUPS:MTL_REFERENCE_TYPE:MEANING' , TRL.REFERENCE_ID , MKC.KANBAN_CARD_NUMBER , TRL.PROJECT_ID , PJM.PROJECT_NUMBER , TRL.TASK_ID , PTS.TASK_NUMBER , '_LA:TRL.LINE_STATUS:MFG_LOOKUPS:MTL_TXN_REQUEST_STATUS:MEANING' , TRL.STATUS_DATE , TRL.CREATED_BY , TRL.CREATION_DATE , TRL.LAST_UPDATED_BY , TRL.LAST_UPDATE_DATE FROM MTL_SYSTEM_ITEMS MSI , GL_CODE_COMBINATIONS GLC , MTL_ITEM_LOCATIONS MIL , MTL_ITEM_LOCATIONS MIT , MTL_TRANSACTION_REASONS MTR , HR_ALL_ORGANIZATION_UNITS HOU , PJM_PROJECTS_V PJM , PA_TASKS PTS , MTL_KANBAN_CARDS MKC , MTL_TRANSACTION_TYPES MTT , MTL_TXN_SOURCE_TYPES MST , MTL_TXN_REQUEST_HEADERS TRH , MTL_TXN_REQUEST_LINES TRL where MSI.INVENTORY_ITEM_ID = TRL.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = TRL.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = TRL.ORGANIZATION_ID AND GLC.CODE_COMBINATION_ID (+)= TRL.TO_ACCOUNT_ID AND MIL.INVENTORY_LOCATION_ID (+)= TRL.FROM_LOCATOR_ID AND MIL.ORGANIZATION_ID (+)= TRL.ORGANIZATION_ID AND MIT.INVENTORY_LOCATION_ID (+)= TRL.TO_LOCATOR_ID AND MIT.ORGANIZATION_ID (+)= TRL.ORGANIZATION_ID AND MTR.REASON_ID (+)= TRL.REASON_ID AND PJM.PROJECT_ID (+)= TRL.PROJECT_ID AND PTS.TASK_ID (+)= TRL.TASK_ID AND PTS.PROJECT_ID (+)= TRL.PROJECT_ID AND MKC.KANBAN_CARD_ID (+)= TRL.REFERENCE_ID AND TRH.HEADER_ID = TRL.HEADER_ID AND MTT.TRANSACTION_TYPE_ID = TRH.TRANSACTION_TYPE_ID AND MTT.TRANSACTION_SOURCE_TYPE_ID = MST.TRANSACTION_SOURCE_TYPE_ID AND '_SEC:TRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT TRL.LINE_ID
, TRL.HEADER_ID
, TRH.REQUEST_NUMBER
, TRL.LINE_NUMBER
, MTT.TRANSACTION_TYPE_NAME
, MST.TRANSACTION_SOURCE_TYPE_NAME
, TRL.ORGANIZATION_ID
, HOU.NAME
, TRL.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, TRL.REVISION
, TRL.FROM_SUBINVENTORY_ID
, TRL.FROM_SUBINVENTORY_CODE
, TRL.FROM_LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, TRL.TO_SUBINVENTORY_CODE
, TRL.TO_SUBINVENTORY_ID
, TRL.TO_LOCATOR_ID
, '_KF:INV:MTLL:MIT'
, TRL.TO_ACCOUNT_ID
, '_KF:SQLGL:GL#:GLC'
, TRL.LOT_NUMBER
, TRL.SERIAL_NUMBER_START
, TRL.SERIAL_NUMBER_END
, TRL.UOM_CODE
, TRL.QUANTITY
, TRL.QUANTITY_DELIVERED
, TRL.QUANTITY_DETAILED
, TRL.DATE_REQUIRED
, TRL.REASON_ID
, MTR.REASON_NAME
, '_LA:TRL.REFERENCE_TYPE_CODE:MFG_LOOKUPS:MTL_REFERENCE_TYPE:MEANING'
, TRL.REFERENCE_ID
, MKC.KANBAN_CARD_NUMBER
, TRL.PROJECT_ID
, PJM.PROJECT_NUMBER
, TRL.TASK_ID
, PTS.TASK_NUMBER
, '_LA:TRL.LINE_STATUS:MFG_LOOKUPS:MTL_TXN_REQUEST_STATUS:MEANING'
, TRL.STATUS_DATE
, TRL.CREATED_BY
, TRL.CREATION_DATE
, TRL.LAST_UPDATED_BY
, TRL.LAST_UPDATE_DATE
FROM MTL_SYSTEM_ITEMS MSI
, GL_CODE_COMBINATIONS GLC
, MTL_ITEM_LOCATIONS MIL
, MTL_ITEM_LOCATIONS MIT
, MTL_TRANSACTION_REASONS MTR
, HR_ALL_ORGANIZATION_UNITS HOU
, PJM_PROJECTS_V PJM
, PA_TASKS PTS
, MTL_KANBAN_CARDS MKC
, MTL_TRANSACTION_TYPES MTT
, MTL_TXN_SOURCE_TYPES MST
, MTL_TXN_REQUEST_HEADERS TRH
, MTL_TXN_REQUEST_LINES TRL
WHERE MSI.INVENTORY_ITEM_ID = TRL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = TRL.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = TRL.ORGANIZATION_ID
AND GLC.CODE_COMBINATION_ID (+)= TRL.TO_ACCOUNT_ID
AND MIL.INVENTORY_LOCATION_ID (+)= TRL.FROM_LOCATOR_ID
AND MIL.ORGANIZATION_ID (+)= TRL.ORGANIZATION_ID
AND MIT.INVENTORY_LOCATION_ID (+)= TRL.TO_LOCATOR_ID
AND MIT.ORGANIZATION_ID (+)= TRL.ORGANIZATION_ID
AND MTR.REASON_ID (+)= TRL.REASON_ID
AND PJM.PROJECT_ID (+)= TRL.PROJECT_ID
AND PTS.TASK_ID (+)= TRL.TASK_ID
AND PTS.PROJECT_ID (+)= TRL.PROJECT_ID
AND MKC.KANBAN_CARD_ID (+)= TRL.REFERENCE_ID
AND TRH.HEADER_ID = TRL.HEADER_ID
AND MTT.TRANSACTION_TYPE_ID = TRH.TRANSACTION_TYPE_ID
AND MTT.TRANSACTION_SOURCE_TYPE_ID = MST.TRANSACTION_SOURCE_TYPE_ID
AND '_SEC:TRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY