APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 117: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.

113: CHANGE HISTORY:
114: S.No Date Author and Details
115: 1. 2002/03/11 Vijay
116: Trigger written to delete data from tables
117: JAI_CMN_MATCH_RECEIPTS, JAI_CMN_MATCH_TAXES.
118: After Match Receipt is done, when back order is done,
119: this trigger enables to match again.
120:
121: 2. 29/11/2005 Aparajita for bug#4036241. Version#115.1

Line 153: Delete from JAI_CMN_MATCH_RECEIPTS

149: -- return;
150: --end if;
151:
152:
153: Delete from JAI_CMN_MATCH_RECEIPTS
154: Where ref_line_id = pr_new.delivery_detail_id;
155:
156: Delete from JAI_CMN_MATCH_TAXES
157: Where ref_line_id = pr_new.delivery_detail_id;

Line 250: JAI_CMN_MATCH_RECEIPTS a

246: IS
247: SELECT
248: sum(a.quantity_applied) quantity_applied
249: FROM
250: JAI_CMN_MATCH_RECEIPTS a
251: WHERE
252: a.ref_line_id = v_delivery_detail_id
253: AND a.order_invoice = 'O' ;
254:

Line 1361: JAI_CMN_MATCH_RECEIPTS a

1357: SELECT
1358:
1359: sum(a.quantity_applied) quantity_applied
1360: FROM
1361: JAI_CMN_MATCH_RECEIPTS a
1362: WHERE
1363: a.ref_line_id = v_delivery_detail_id;
1364:
1365: v_matched_qty NUMBER; --File.Sql.35 Cbabu := 0;