Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | This view is used in the OPM Pick Lots form (ICPCKLOT.fmb), and gives the Move Order Lines information for the form. |
Implementation/DBA Data: | APPS.IC_MOVE_ORDER_LINES_V |
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)