VIEW: APPS.GME_INGRED_PICK_VW

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)