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 736: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt

732: CURSOR tax_lines1_cur(tran_id NUMBER,ven_id NUMBER)
733: IS
734: SELECT jrl.tax_amount tax_amount, jrl.tax_id, jrl.currency,jrl.tax_type tax_type, jrl.modvat_flag,
735: jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
736: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt
737: WHERE jrl.shipment_line_id = rsl.shipment_line_id
738: AND rt.shipment_line_id = rsl.shipment_line_id
739: AND rt.transaction_id = tran_id
740: AND jrl.vendor_id = ven_id

Line 768: , RCV_SHIPMENT_LINES RSL

764: , jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
765: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
766: FROM
767: JAI_RCV_LINE_TAXES jrl
768: , RCV_SHIPMENT_LINES RSL
769: , RCV_TRANSACTIONS RT
770: , jai_cmn_taxes_all jcta
771: WHERE jrl.shipment_line_id = rsl.shipment_line_id
772: AND rt.shipment_line_id = rsl.shipment_line_id

Line 807: , rcv_shipment_lines rsl

803: , jrl.tax_line_no tax_line_no --Added by kunkumar for bug 5593895
804: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
805: FROM
806: jai_rcv_line_taxes jrl
807: , rcv_shipment_lines rsl
808: , rcv_transactions rt
809: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
810: WHERE jrl.shipment_line_id = rsl.shipment_line_id
811: AND rt.shipment_line_id = rsl.shipment_line_id

Line 837: , rcv_shipment_lines rsl

833: , jrl.tax_line_no tax_line_no
834: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
835: FROM
836: jai_retro_tax_changes jrl
837: , rcv_shipment_lines rsl
838: , rcv_transactions rt
839: , jai_retro_line_changes jrlc
840: , jai_cmn_taxes_all jcta
841: WHERE jrlc.doc_line_id = rsl.shipment_line_id

Line 923: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;

919: v_batch_id NUMBER;
920: c_tax_rec c_tax%ROWTYPE;
921: v_source VARCHAR2(25);
922: apccid ap_invoices_all.ACCTS_PAY_CODE_COMBINATION_ID%TYPE;
923: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
924: cur_items_rec cur_items%ROWTYPE;
925: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
926: from_po_distributions_rec from_po_distributions%ROWTYPE;
927: for_dist_insertion_rec for_dist_insertion%ROWTYPE;

Line 5840: , rcv_shipment_lines rsl

5836: , jrl.tax_line_no --Added by kunkumar for bug#5593895
5837: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
5838: FROM
5839: JAI_RCV_LINE_TAXES jrl
5840: , rcv_shipment_lines rsl
5841: , rcv_transactions rt
5842: , jai_cmn_taxes_all jcta
5843: WHERE jrl.shipment_line_id = rsl.shipment_line_id
5844: AND rt.shipment_line_id = rsl.shipment_line_id

Line 5954: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;

5950: v_dist_reversal_cnt NUMBER;
5951: v_batch_id NUMBER;
5952: c_tax_rec c_tax%ROWTYPE;
5953: v_source VARCHAR2(25);
5954: shpmnt_ln_id rcv_shipment_lines.shipment_line_id%TYPE;
5955: cur_items_rec cur_items%ROWTYPE;
5956: caid gl_sets_of_books.chart_of_accounts_id%TYPE;
5957: for_dist_insertion_rec for_dist_insertion%ROWTYPE;
5958: cum_tax_amt NUMBER := 0;