VIEW: APPS.IC_MOVE_ORDER_LINES_V

Source

View Text - Preformatted

SELECT MOL.INVENTORY_ITEM_ID, ITM.ITEM_ID, ITM.DUALUM_IND, ITM.NONINV_IND, ITM.LOT_INDIVISIBLE, ITM.ITEM_NO, ITM.ITEM_DESC1, MOL.ORGANIZATION_ID, WHS.WHSE_CODE, WHS.WHSE_NAME, MOL.UOM_CODE, MOL.SECONDARY_UOM_CODE, NVL(MOL.QUANTITY,0) QUANTITY, NVL(MOL.SECONDARY_QUANTITY,0) SECONDARY_QUANTITY, NVL(MOL.QUANTITY_DETAILED,0) QUANTITY_DETAILED, NVL(MOL.SECONDARY_QUANTITY_DETAILED,0) SECONDARY_QUANTITY_DETAILED, NVL(MOL.QUANTITY_DELIVERED,0) QUANTITY_DELIVERED, NVL(MOL.SECONDARY_QUANTITY_DELIVERED,0) SECONDARY_QUANTITY_DELIVERED, NVL(MOL.TXN_SOURCE_LINE_ID,0) TXN_SOURCE_LINE_ID, MOL.LINE_ID, MOL.LINE_STATUS FROM IC_TXN_REQUEST_LINES MOL, IC_WHSE_MST WHS, IC_ITEM_MST ITM, MTL_SYSTEM_ITEMS MTL WHERE MOL.ORGANIZATION_ID = WHS.MTL_ORGANIZATION_ID AND MOL.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID AND MOL.ORGANIZATION_ID = MTL.ORGANIZATION_ID AND MTL.SEGMENT1 = ITM.ITEM_NO AND MOL.LINE_STATUS IN (3, 7)

View Text - HTML Formatted

SELECT MOL.INVENTORY_ITEM_ID
, ITM.ITEM_ID
, ITM.DUALUM_IND
, ITM.NONINV_IND
, ITM.LOT_INDIVISIBLE
, ITM.ITEM_NO
, ITM.ITEM_DESC1
, MOL.ORGANIZATION_ID
, WHS.WHSE_CODE
, WHS.WHSE_NAME
, MOL.UOM_CODE
, MOL.SECONDARY_UOM_CODE
, NVL(MOL.QUANTITY
, 0) QUANTITY
, NVL(MOL.SECONDARY_QUANTITY
, 0) SECONDARY_QUANTITY
, NVL(MOL.QUANTITY_DETAILED
, 0) QUANTITY_DETAILED
, NVL(MOL.SECONDARY_QUANTITY_DETAILED
, 0) SECONDARY_QUANTITY_DETAILED
, NVL(MOL.QUANTITY_DELIVERED
, 0) QUANTITY_DELIVERED
, NVL(MOL.SECONDARY_QUANTITY_DELIVERED
, 0) SECONDARY_QUANTITY_DELIVERED
, NVL(MOL.TXN_SOURCE_LINE_ID
, 0) TXN_SOURCE_LINE_ID
, MOL.LINE_ID
, MOL.LINE_STATUS
FROM IC_TXN_REQUEST_LINES MOL
, IC_WHSE_MST WHS
, IC_ITEM_MST ITM
, MTL_SYSTEM_ITEMS MTL
WHERE MOL.ORGANIZATION_ID = WHS.MTL_ORGANIZATION_ID
AND MOL.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND MOL.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND MTL.SEGMENT1 = ITM.ITEM_NO
AND MOL.LINE_STATUS IN (3
, 7)