[Home] [Help]
86: l_where := l_where || ' AND LPAD(batch_no, 32, 0) >= LPAD(NVL(:from_batch, batch_no), 32, 0)'
87: || ' AND LPAD(batch_no, 32, 0) <= LPAD(NVL(:to_batch, batch_no), 32, 0)'
88: || ' AND NVL(oprn_no, '' '') LIKE NVL(:oprn_no, NVL(oprn_no, '' ''))'
89: || ' AND NVL(oprn_vers, -1) = NVL(:oprn_vers, NVL(oprn_vers, -1))'
90: || ' AND (:product_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
91: || ' WHERE organization_id = :organization_id'
92: || ' AND line_type = 1 AND inventory_item_id IN'
93: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
94: || ' AND concatenated_segments LIKE :product_no)))'
91: || ' WHERE organization_id = :organization_id'
92: || ' AND line_type = 1 AND inventory_item_id IN'
93: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
94: || ' AND concatenated_segments LIKE :product_no)))'
95: || ' AND (:ingredient_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
96: || ' WHERE organization_id = :organization_id'
97: || ' AND line_type = -1 AND inventory_item_id IN'
98: || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
99: || ' AND concatenated_segments LIKE :ingredient_no)))'
195: IS
196: l_api_name CONSTANT VARCHAR2 (30) := 'get_open_qty';
197: l_open_qty NUMBER := 0;
198: l_return_status VARCHAR2 (1);
199: l_mtl_dtl_rec gme_material_details%ROWTYPE;
200: BEGIN
201: IF g_debug <= gme_debug.g_log_procedure THEN
202: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
203: || l_api_name);
893: || l_backordered_qty);
894: END IF;
895:
896: IF (l_backordered_qty > 0) THEN
897: UPDATE gme_material_details
898: SET backordered_qty = l_backordered_qty
899: WHERE material_detail_id = p_mo_line_rec.txn_source_line_id;
900: END IF;
901: