APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 339: FROM JAI_CMN_MATCH_RECEIPTS A

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

Line 356: FROM JAI_CMN_MATCH_RECEIPTS A

352: WHERE delivery_detail_id = p_picking_line_id;
353:
354: CURSOR matched_receipt_cur(p_reference_line_id IN NUMBER) IS
355: SELECT A.receipt_id, A.quantity_applied
356: FROM JAI_CMN_MATCH_RECEIPTS A
357: WHERE A.ref_line_id = p_reference_line_id
358: AND ORDER_INVOICE = 'O' -- cbabu for Bug# 2736191
359: AND A.quantity_applied > 0;
360:

Line 2306: UPDATE JAI_CMN_MATCH_RECEIPTS

2302: CLOSE ship_bill_cur;
2303: -- End, cbabu for Bug# 2736191
2304:
2305: lv_statement_no := '53';
2306: UPDATE JAI_CMN_MATCH_RECEIPTS
2307: SET ship_status='CLOSED'
2308: WHERE ref_line_id = each_record.delivery_detail_id
2309: AND ORDER_INVOICE = 'O'; -- cbabu for Bug# 2736191
2310: