[Home] [Help]
105: l_where := l_where || ' AND LPAD(batch_no, 32, 0) >= LPAD(NVL(:from_batch, batch_no), 32, 0)'
106: || ' AND LPAD(batch_no, 32, 0) <= LPAD(NVL(:to_batch, batch_no), 32, 0)'
107: || ' AND NVL(oprn_no, '' '') LIKE NVL(:oprn_no, NVL(oprn_no, '' ''))'
108: || ' AND NVL(oprn_vers, -1) = NVL(:oprn_vers, NVL(oprn_vers, -1))'
109: || ' AND (:product_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
110: || ' WHERE organization_id = :organization_id'
111: || ' AND line_type = 1 AND inventory_item_id IN'
112: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
113: || ' AND concatenated_segments LIKE :product_no)))'
110: || ' WHERE organization_id = :organization_id'
111: || ' AND line_type = 1 AND inventory_item_id IN'
112: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
113: || ' AND concatenated_segments LIKE :product_no)))'
114: || ' AND (:ingredient_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
115: || ' WHERE organization_id = :organization_id'
116: || ' AND line_type = -1 AND inventory_item_id IN'
117: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
118: || ' AND concatenated_segments LIKE :ingredient_no)))'
216: IS
217: l_api_name CONSTANT VARCHAR2 (30) := 'get_open_qty';
218: l_open_qty NUMBER := 0;
219: l_return_status VARCHAR2 (1);
220: l_mtl_dtl_rec gme_material_details%ROWTYPE;
221: BEGIN
222: IF g_debug <= gme_debug.g_log_procedure THEN
223: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
224: || l_api_name);
707: l_is_serial_control BOOLEAN;
708: l_is_revision_control BOOLEAN;
709: l_is_lot_control BOOLEAN;
710: item_rec mtl_system_items%ROWTYPE;
711: l_mtl_dtl_rec gme_material_details%ROWTYPE;
712: l_qty_on_hand NUMBER;
713: l_qty_res_on_hand NUMBER;
714: l_qty_res NUMBER;
715: l_qty_sug NUMBER;
1196: || l_backordered_qty);
1197: END IF;
1198:
1199: IF (l_backordered_qty > 0) THEN
1200: UPDATE gme_material_details
1201: SET backordered_qty = l_backordered_qty
1202: WHERE material_detail_id = p_mo_line_rec.txn_source_line_id;
1203: END IF;
1204: