APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 264: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct

260: PRAGMA AUTONOMOUS_TRANSACTION;
261: /* Cursor to get the localization taxes attached to the item line*/
262: Cursor get_loc_tax(cp_invoice_id number,cp_inv_distid number) is
263: select jm.*
264: from JAI_AP_MATCH_INV_TAXES jm,jai_cmn_taxes_all jct
265: where jm.tax_id=jct.tax_id
266: and invoice_id = cp_invoice_id
267: and parent_invoice_distribution_id=cp_inv_distid
268: and line_type_lookup_code='MISCELLANEOUS'

Line 1232: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax

1228: This issue will particularly occurs if the PO doesnot have the taxes
1229: attached.
1230:
1231: Technical details:
1232: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax
1233: amount.
1234: But jai_ap_match_inv_taxes.shipment_line_id will be always null.
1235: Hence the receipt tax amount retrieved is null ,due to which ERV tax amount
1236: is null and the accounting didnt happen for the ERV line

Line 1234: But jai_ap_match_inv_taxes.shipment_line_id will be always null.

1230:
1231: Technical details:
1232: jai_ap_match_inv_taxes.shipment_line_id is used to get the receipt tax
1233: amount.
1234: But jai_ap_match_inv_taxes.shipment_line_id will be always null.
1235: Hence the receipt tax amount retrieved is null ,due to which ERV tax amount
1236: is null and the accounting didnt happen for the ERV line
1237:
1238: fix :