View: GME_INGRED_PICK_VW

Product:	GME - Process Manufacturing Process Execution
Description:	Ingredient Picking View
Implementation/DBA Data:	APPS.GME_INGRED_PICK_VW

View Text

SELECT H.BATCH_NO
, H.BATCH_STATUS
, H.ORGANIZATION_ID
, H.RECIPE_VALIDITY_RULE_ID
, H.FORMULA_ID
, H.ROUTING_ID
, H.BATCH_ID
, H.PLAN_START_DATE
, H.PLAN_CMPLT_DATE
, H.ACTUAL_START_DATE
, M.LINE_NO
, M.LINE_TYPE
, M.INVENTORY_ITEM_ID
, M.SUBINVENTORY
, M.LOCATOR_ID
, M.DTL_UM
, M.MATERIAL_REQUIREMENT_DATE
, M.BACKORDERED_QTY
, M.MATERIAL_DETAIL_ID
, M.REVISION
, M.PLAN_QTY
, M.ACTUAL_QTY
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, GME_PICKING_PVT.GET_OPEN_QTY(M.ORGANIZATION_ID
, M.BATCH_ID
, M.MATERIAL_DETAIL_ID
, M.INVENTORY_ITEM_ID
, M.SUBINVENTORY
, M.PLAN_QTY
, M.WIP_PLAN_QTY
, M.ACTUAL_QTY
, M.BACKORDERED_QTY
, M.DTL_UM) OPEN_QTY
, S.BATCHSTEP_NO
, S.OPRN_ID
, O.OPRN_VERS
, O.OPRN_NO
FROM GME_BATCH_HEADER H
, GME_MATERIAL_DETAILS M
, MTL_SYSTEM_ITEMS_VL MSI
, GME_BATCH_STEP_ITEMS I
, GME_BATCH_STEPS S
, GMD_OPERATIONS_B O
WHERE H.BATCH_STATUS IN (1
, 2)
AND H.BATCH_TYPE = 0
AND H.UPDATE_INVENTORY_IND = 'Y'
AND M.BATCH_ID = H.BATCH_ID
AND M.ORGANIZATION_ID = H.ORGANIZATION_ID
AND M.LINE_TYPE = -1
AND M.PHANTOM_TYPE = 0
AND M.SUBINVENTORY IS NOT NULL
AND (H.BATCH_STATUS = 1 OR (M.WIP_PLAN_QTY > M.ACTUAL_QTY))
AND MSI.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'
AND M.MATERIAL_DETAIL_ID = I.MATERIAL_DETAIL_ID(+)
AND I.BATCHSTEP_ID = S.BATCHSTEP_ID(+)
AND S.OPRN_ID = O.OPRN_ID(+)

Columns