eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_MATCH_TAX_PKG dependencies on RCV_SHIPMENT_LINES

Line 1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt

996: jrl.tax_type tax_type,
997: jrl.modvat_flag,
998: jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
999: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt
1001: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1002: AND rt.shipment_line_id = rsl.shipment_line_id
1003: AND rt.transaction_id = tran_id
1004: AND jrl.vendor_id = ven_id

Line 1035: , RCV_SHIPMENT_LINES RSL

1031: ,nvl(jcta.adhoc_flag,'N') adhoc_flag --12697697
1032:
1033: FROM
1034: JAI_RCV_LINE_TAXES jrl
1035: , RCV_SHIPMENT_LINES RSL
1036: , RCV_TRANSACTIONS RT
1037: , jai_cmn_taxes_all jcta
1038: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1039: AND rt.shipment_line_id = rsl.shipment_line_id

Line 1081: , rcv_shipment_lines rsl

1077: ,jcta.vat_flag vat_flag
1078: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12697697
1079: FROM
1080: jai_rcv_line_taxes jrl
1081: , rcv_shipment_lines rsl
1082: , rcv_transactions rt
1083: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
1084: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1085: AND rt.shipment_line_id = rsl.shipment_line_id

Line 1117: , rcv_shipment_lines rsl

1113: ,jcta.vat_flag vat_flag
1114: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12697697
1115: FROM
1116: jai_retro_tax_changes jrl
1117: , rcv_shipment_lines rsl
1118: , rcv_transactions rt
1119: , jai_retro_line_changes jrlc
1120: , jai_cmn_taxes_all jcta
1121: WHERE jrlc.doc_line_id = rsl.shipment_line_id

Line 1219: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;

1215: v_batch_id NUMBER;
1216: c_tax_rec c_tax%ROWTYPE;
1217: v_source VARCHAR2(25);
1218: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;
1219: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
1220: cur_items_rec cur_items%ROWTYPE;
1221: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
1222: from_po_distributions_rec from_po_distributions%ROWTYPE;
1223: for_dist_insertion_rec for_dist_insertion%ROWTYPE;

Line 7391: , rcv_shipment_lines rsl

7387: , jrl.tax_line_no --Added by kunkumar for bug#5593895
7388: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7389: FROM
7390: JAI_RCV_LINE_TAXES jrl
7391: , rcv_shipment_lines rsl
7392: , rcv_transactions rt
7393: , jai_cmn_taxes_all jcta
7394: WHERE jrl.shipment_line_id = rsl.shipment_line_id
7395: AND rt.shipment_line_id = rsl.shipment_line_id

Line 7505: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;

7501: v_dist_reversal_cnt NUMBER;
7502: v_batch_id NUMBER;
7503: c_tax_rec c_tax%ROWTYPE;
7504: v_source VARCHAR2(25);
7505: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
7506: cur_items_rec cur_items%ROWTYPE;
7507: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
7508: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
7509: cum_tax_amt NUMBER := 0;