APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 127: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.

123: CHANGE HISTORY:
124: S.No Date Author and Details
125: 1. 2002/03/11 Vijay
126: Trigger written to delete data from tables
127: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.
128: After Match Receipt is done, when back order is done,
129: this trigger enables to match again.
130:
131: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1

Line 163: Delete from JAI_CMN_MATCH_RECEIPTS

159: -- return;
160: --end if;
161:
162:
163: Delete from JAI_CMN_MATCH_RECEIPTS
164: Where ref_line_id = pr_new.delivery_detail_id;
165:
166: Delete from JAI_CMN_MATCH_TAXES
167: Where ref_line_id = pr_new.delivery_detail_id;

Line 272: JAI_CMN_MATCH_RECEIPTS a

268: IS
269: SELECT
270: sum(a.quantity_applied) quantity_applied
271: FROM
272: JAI_CMN_MATCH_RECEIPTS a
273: WHERE
274: a.ref_line_id = v_delivery_detail_id
275: AND a.order_invoice = 'O' ;
276:

Line 1601: JAI_CMN_MATCH_RECEIPTS a

1597: SELECT
1598:
1599: sum(a.quantity_applied) quantity_applied
1600: FROM
1601: JAI_CMN_MATCH_RECEIPTS a
1602: WHERE
1603: a.ref_line_id = v_delivery_detail_id;
1604:
1605: v_matched_qty NUMBER; --File.Sql.35 Cbabu := 0;

Line 3661: FROM JAI_CMN_MATCH_RECEIPTS

3657: WHERE organization_id = pr_trig_row.organization_id;
3658:
3659: CURSOR c_matched_receipts IS
3660: SELECT receipt_id,receipt_quantity_applied
3661: FROM JAI_CMN_MATCH_RECEIPTS
3662: WHERE ref_line_id = pr_trig_row.delivery_detail_id;
3663:
3664: CURSOR c_rg23d_details(p_register_id NUMBER) IS
3665: SELECT closing_balance_qty - opening_balance_qty receipt_quantity,