View: MTL_TXN_BACKORDERS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_TXN_BACKORDERS_V

View Text

SELECT MOH.HEADER_ID
, MOH.REQUEST_NUMBER
, MOH.MOVE_ORDER_TYPE
, MFG1.MEANING
, MOH.ORGANIZATION_ID
, MOH.DATE_REQUIRED
, MFG2.MEANING
, MOH.STATUS_DATE
, MOL.LINE_ID
, MOL.LINE_NUMBER
, MOL.INVENTORY_ITEM_ID
, MOL.REVISION
, MOL.FROM_SUBINVENTORY_CODE
, MOL.FROM_LOCATOR_ID
, MOL.TO_SUBINVENTORY_CODE
, MOL.TO_LOCATOR_ID
, MOL.LOT_NUMBER
, MOL.SERIAL_NUMBER_START
, MOL.SERIAL_NUMBER_END
, MOL.UOM_CODE
, (MOL.QUANTITY -MOL.QUANTITY_DETAILED) BACKORDERED_QUANTITY
, MOL.REASON_ID
, MOL.REFERENCE
, MOL.REFERENCE_TYPE_CODE
, MOL.REFERENCE_ID
, MOL.PROJECT_ID
, MOL.TASK_ID
, MOL.TRANSACTION_HEADER_ID
, MFG3.MEANING
, MOL.STATUS_DATE
, MOL.TO_ORGANIZATION_ID
, MOL.TRANSACTION_TYPE_ID
, MOL.TRANSACTION_SOURCE_TYPE_ID
, MOL.TXN_SOURCE_ID
, MOL.TXN_SOURCE_LINE_ID
, MOL.TXN_SOURCE_LINE_DETAIL_ID
, MOL.PICK_STRATEGY_ID
, MOL.PUT_AWAY_STRATEGY_ID
, MOL.FROM_COST_GROUP_ID
, CST.COST_GROUP
, MOL.TO_COST_GROUP_ID
, CST2.COST_GROUP
FROM MTL_TXN_REQUEST_HEADERS MOH
, MTL_TXN_REQUEST_LINES MOL
, MFG_LOOKUPS MFG1
, MFG_LOOKUPS MFG2
, MFG_LOOKUPS MFG3
, CST_COST_GROUPS CST
, CST_COST_GROUPS CST2
WHERE MOH.HEADER_ID = MOL.HEADER_ID
AND MOH.MOVE_ORDER_TYPE = MFG1.LOOKUP_CODE
AND MFG1.LOOKUP_TYPE = 'MOVE_ORDER_TYPE'
AND MOH.HEADER_STATUS = MFG2.LOOKUP_CODE
AND MFG2.LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS'
AND MOL.LINE_STATUS = MFG3.LOOKUP_CODE
AND MFG3.LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS'
AND MOL.QUANTITY_DETAILED IS NOT NULL
AND MOL.QUANTITY > MOL.QUANTITY_DETAILED
AND CST.COST_GROUP_ID(+) = MOL.FROM_COST_GROUP_ID
AND CST2.COST_GROUP_ID(+) = MOL.TO_COST_GROUP_ID

Columns