87: IS
88: SELECT
89: sum(a.quantity_applied) quantity_applied
90: FROM
91: JAI_CMN_MATCH_RECEIPTS a
92: WHERE
93: a.ref_line_id = v_delivery_detail_id
94: AND a.order_invoice = 'O' ;
95:
694: SELECT
695:
696: sum(a.quantity_applied) quantity_applied
697: FROM
698: JAI_CMN_MATCH_RECEIPTS a
699: WHERE
700: a.ref_line_id = v_delivery_detail_id;
701:
702: v_matched_qty NUMBER;
2028: WHERE organization_id = pr_trig_row.organization_id;
2029:
2030: CURSOR c_matched_receipts IS
2031: SELECT receipt_id, receipt_quantity_applied
2032: FROM JAI_CMN_MATCH_RECEIPTS
2033: WHERE ref_line_id = pr_trig_row.delivery_detail_id;
2034:
2035: CURSOR c_rg23d_details(p_register_id NUMBER) IS
2036: SELECT closing_balance_qty - opening_balance_qty receipt_quantity,
2807: SELECT
2808:
2809: sum(a.quantity_applied) quantity_applied
2810: FROM
2811: JAI_CMN_MATCH_RECEIPTS a
2812: WHERE
2813: a.ref_line_id = v_delivery_detail_id;
2814:
2815: CURSOR Trading_register_code_cur( p_organization_id NUMBER,