APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 334: FROM JAI_CMN_MATCH_RECEIPTS A

330: AND A.REGISTER_CODE LIKE '23D%';
331:
332: CURSOR matched_receipt_cur1(p_reference_line_id IN NUMBER) IS
333: SELECT SUM(A.quantity_applied) quantity_applied, A.subinventory
334: FROM JAI_CMN_MATCH_RECEIPTS A
335: WHERE A.ref_line_id = p_reference_line_id
336: AND ORDER_INVOICE = 'O'; -- cbabu for Bug# 2736191
337: -- GROUP BY A.subinventory; -- cbabu for Bug# 2736191
338:

Line 351: FROM JAI_CMN_MATCH_RECEIPTS A

347: WHERE delivery_detail_id = p_picking_line_id;
348:
349: CURSOR matched_receipt_cur(p_reference_line_id IN NUMBER) IS
350: SELECT A.receipt_id, A.quantity_applied
351: FROM JAI_CMN_MATCH_RECEIPTS A
352: WHERE A.ref_line_id = p_reference_line_id
353: AND ORDER_INVOICE = 'O' -- cbabu for Bug# 2736191
354: AND A.quantity_applied > 0;
355:

Line 2204: UPDATE JAI_CMN_MATCH_RECEIPTS

2200: CLOSE ship_bill_cur;
2201: -- End, cbabu for Bug# 2736191
2202:
2203: lv_statement_no := '53';
2204: UPDATE JAI_CMN_MATCH_RECEIPTS
2205: SET ship_status='CLOSED'
2206: WHERE ref_line_id = each_record.delivery_detail_id
2207: AND ORDER_INVOICE = 'O'; -- cbabu for Bug# 2736191
2208: