DBA Data[Home] [Help]

APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 91: JAI_CMN_MATCH_RECEIPTS a

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:

Line 698: JAI_CMN_MATCH_RECEIPTS a

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;

Line 2032: FROM JAI_CMN_MATCH_RECEIPTS

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,

Line 2811: JAI_CMN_MATCH_RECEIPTS a

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,