DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_PO_TAXES

Line 1216: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c

1212: CURSOR Get_Receipt_taxes IS SELECT a.tax_id tax_id_po, a.tax_line_no tax_line_no_po, c.tax_id , c.tax_line_no,
1213: a.precedence_1 p_1, a.precedence_2 p_2, a.precedence_3 p_3, a.precedence_4 p_4, a.precedence_5 p_5,
1214: a.precedence_6 p_6, a.precedence_7 p_7, a.precedence_8 p_8, a.precedence_9 p_9, a.precedence_10 p_10,
1215: c.qty_rate, c.tax_rate, c.tax_amount, c.uom
1216: FROM JAI_PO_TAXES a, JAI_CMN_TAXES_ALL b, JAI_RCV_LINE_TAXES c
1217: WHERE c.tax_line_no > nvl(v_tax_line_no,0)
1218: AND a.tax_id = b.tax_id
1219: AND c.tax_id = b.tax_id
1220: AND (c.shipment_line_id,a.line_location_id) = (SELECT shipment_line_id,po_line_location_id

Line 1859: on JAI_PO_TAXES and jai_rcv_tax_pkg.default_taxes_onto_line. The problem with cursor

1855: In the case of a manual ar invoice which is matched against an iso receipt or
1856: manual rg23d receipt, then excise taxes were not getting populated into the
1857: ar invoice from the rg23 receipt.
1858: The reason for this behaviour is that , ther ar_tax_cur was written to work based
1859: on JAI_PO_TAXES and jai_rcv_tax_pkg.default_taxes_onto_line. The problem with cursor
1860: is that , manual rg23d receipts and receipts created by iso transactions are not
1861: picked by this cursor.
1862:
1863: Hence, the cursor which was used earlier has been retained , which picks the taxes