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_ST_REVERSE_PROCESS dependencies on JAI_CMN_TAXES_ALL

Line 474: FROM jai_cmn_taxes_all

470: adhoc_flag,
471: NVL (tax_rate, -1) tax_rate,
472: tax_type,
473: NVL(rounding_factor,0) rounding_factor
474: FROM jai_cmn_taxes_all
475: WHERE tax_id = pn_tax_id;
476:
477: CURSOR get_ap_tax_dtl (cn_dist_id NUMBER)IS
478: SELECT modvat_flag

Line 2062: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax

2058: , MAX(jcdt.source_doc_parent_line_no) source_doc_parent_line_no
2059: , MAX(jcta.inclusive_tax_flag) inc_tax_flag
2060: FROM
2061: jai_cmn_document_taxes jcdt
2062: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
2063: WHERE jcdt.source_doc_id = pn_invoice_id
2064: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
2065: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
2066: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

Line 2127: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax

2123: , jcdt.source_doc_parent_line_no
2124: , jcta.inclusive_tax_flag inc_tax_flag --Added by Eric for Inclusive Tax
2125: FROM
2126: jai_cmn_document_taxes jcdt
2127: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
2128: WHERE jcdt.source_doc_id = pn_invoice_id
2129: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
2130: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
2131: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

Line 2207: jai_cmn_taxes_all

2203: , NVL (tax_rate, -1) tax_rate
2204: , tax_type
2205: , NVL(rounding_factor,0) rounding_factor
2206: FROM
2207: jai_cmn_taxes_all
2208: WHERE tax_id = pn_tax_id;
2209:
2210: CURSOR ap_invoice_dist_cur (pn_line_number NUMBER , pn_distribution_line_number number) IS
2211: SELECT

Line 3274: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax

3270: ,nvl(jcta.vat_flag,'N') VAT_FLAG
3271: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
3272: FROM
3273: JAI_PO_TAXES jpt
3274: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax
3275: -- WHERE line_focus_id = focus_id
3276: WHERE line_location_id = p_line_location_id -- 3096578
3277: AND NVL(UPPER(jpt.tax_type), 'A')
3278: NOT IN( 'TDS'

Line 3313: , jai_cmn_taxes_all jcta

3309: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
3310: FROM
3311: jai_retro_tax_changes jrl
3312: , jai_retro_line_changes jrlc
3313: , jai_cmn_taxes_all jcta
3314: WHERE jrlc.line_location_id = p_line_location_id
3315: AND jrlc.line_change_id = jrl.line_change_id
3316: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
3317: FROM jai_retro_line_changes

Line 3352: FROM JAI_CMN_TAXES_ALL

3348: adhoc_flag, -- added by aparajita on 23/01/2003 for bug # 2694011
3349: nvl(tax_rate,-1) tax_rate, --Modified by kunkumar for bug 5593895
3350: tax_type,
3351: NVL(rounding_factor,0) rounding_factor /* added by vumaasha for bug 6761425 */
3352: FROM JAI_CMN_TAXES_ALL
3353: WHERE tax_id = t_id;
3354:
3355: CURSOR c_inv(inv_id NUMBER) IS
3356: SELECT batch_id,source

Line 3421: , jai_cmn_taxes_all jcta

3417: FROM
3418: JAI_RCV_LINE_TAXES jrl
3419: , RCV_SHIPMENT_LINES RSL
3420: , RCV_TRANSACTIONS RT
3421: , jai_cmn_taxes_all jcta
3422: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3423: AND rt.shipment_line_id = rsl.shipment_line_id
3424: AND rt.transaction_id = tran_id
3425: AND jrl.vendor_id = ven_id

Line 3467: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax

3463: FROM
3464: jai_rcv_line_taxes jrl
3465: , rcv_shipment_lines rsl
3466: , rcv_transactions rt
3467: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
3468: WHERE jrl.shipment_line_id = rsl.shipment_line_id
3469: AND rt.shipment_line_id = rsl.shipment_line_id
3470: AND rt.transaction_id = tran_id
3471: AND jrl.vendor_id = ven_id

Line 3504: , jai_cmn_taxes_all jcta

3500: jai_retro_tax_changes jrl
3501: , rcv_shipment_lines rsl
3502: , rcv_transactions rt
3503: , jai_retro_line_changes jrlc
3504: , jai_cmn_taxes_all jcta
3505: WHERE jrlc.doc_line_id = rsl.shipment_line_id
3506: AND jrlc.line_change_id = jrl.line_change_id
3507: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
3508: FROM jai_retro_line_changes

Line 3551: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is

3547: where currency_code = cp_currency_code;
3548:
3549: -- ends here additions by ssumaith -bug# 3127834
3550: --Added by kunkumar for porting 4454499
3551: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
3552: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
3553: select NVL(rounding_factor,2) -- for bug 16226028
3554: from jai_cmn_taxes_all
3555: where tax_id = cp_tax_id ;

Line 3554: from jai_cmn_taxes_all

3550: --Added by kunkumar for porting 4454499
3551: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
3552: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
3553: select NVL(rounding_factor,2) -- for bug 16226028
3554: from jai_cmn_taxes_all
3555: where tax_id = cp_tax_id ;
3556:
3557: /*Bug 8866084 - Added cursor to fetch Source of Invoice*/
3558: cursor c_get_ap_invoice_src (p_inv_id NUMBER)

Line 3567: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;

3563:
3564: ln_source VARCHAR2(50);
3565:
3566: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
3567: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
3568: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
3569: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
3570: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
3571: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 3848: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct

3844: cursor c_get_orig_tax_line
3845: (p_orig_invoice_id number, p_orig_invoice_dist_id number, p_tax_id number) is
3846: -- 5763527 , Added SUM as there can be two tax lines against the same tax_id because of partialy recoverable taxes
3847: select sum(jam.tax_amount) tax_amount-- project costing fwd porting
3848: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct
3849: where p_orig_invoice_id = p_orig_invoice_id
3850: and parent_invoice_distribution_id = p_orig_invoice_dist_id
3851: and jam.tax_id = p_tax_id
3852: --start additions for bug#10167393

Line 5474: FROM JAI_CMN_TAXES_ALL

5470: CURSOR c_tax(t_id NUMBER) IS
5471: SELECT tax_name, tax_account_id, mod_cr_percentage, tax_type,
5472: NVL(rounding_factor,0) rounding_factor /* added by vumaasha for bug 6761425 */
5473: -- bug 3051832, mod_cr_percentage added by aparajita on 10/10/2002 for bug # 2616100
5474: FROM JAI_CMN_TAXES_ALL
5475: WHERE tax_id = t_id;
5476:
5477: CURSOR c_inv(inv_id NUMBER) IS
5478: SELECT batch_id,source

Line 5539: , jai_cmn_taxes_all jcta

5535: FROM
5536: JAI_RCV_LINE_TAXES jrl
5537: , rcv_shipment_lines rsl
5538: , rcv_transactions rt
5539: , jai_cmn_taxes_all jcta
5540: WHERE jrl.shipment_line_id = rsl.shipment_line_id
5541: AND rt.shipment_line_id = rsl.shipment_line_id
5542: AND rt.transaction_id = tran_id
5543: AND jrl.vendor_id = ven_id

Line 5577: , jai_cmn_taxes_all jcta

5573: , jpt.tax_line_no
5574: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
5575: FROM
5576: jai_po_taxes jpt
5577: , jai_cmn_taxes_all jcta
5578: WHERE jpt.line_location_id = p_line_location_id
5579: AND jcta.tax_id = jpt.tax_id
5580: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5581: 'CVD',

Line 5603: , jai_cmn_taxes_all jcta

5599: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag
5600: FROM
5601: jai_cmn_lines lines
5602: , jai_cmn_document_Taxes taxes
5603: , jai_cmn_taxes_all jcta
5604: WHERE lines.cmn_line_id = taxes.source_doc_line_id
5605: AND taxes.source_doc_type = 'ASBN'
5606: AND lines.po_line_location_id = p_line_location_id
5607: AND lines.shipment_number = cp_shipment_num

Line 5749: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is

5745: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
5746: and attribute_code = cp_tax_type;
5747:
5748: /*Added by kunkumar for bug#5593895*/
5749: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
5750: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
5751: select NVL(rounding_factor,2) -- for bug 16226028
5752: from jai_cmn_taxes_all
5753: where tax_id = cp_tax_id ;

Line 5752: from jai_cmn_taxes_all

5748: /*Added by kunkumar for bug#5593895*/
5749: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
5750: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
5751: select NVL(rounding_factor,2) -- for bug 16226028
5752: from jai_cmn_taxes_all
5753: where tax_id = cp_tax_id ;
5754: /*End, Added by kunkumar for bug#5593895*/
5755:
5756: r_rcv_transactions c_rcv_transactions%rowtype;

Line 5772: ln_tax_precision JAI_CMN_TAXES_ALL.rounding_factor%type;--Added by kunkumar for bug#5593895

5768: r_vat_regimes c_jai_regimes%rowtype;
5769: r_vat_regime_tax_type c_regime_tax_type%rowtype;
5770:
5771: ln_base_amount number ; --Added by kunkumar for bug#5593895
5772: ln_tax_precision JAI_CMN_TAXES_ALL.rounding_factor%type;--Added by kunkumar for bug#5593895
5773: l_api_name CONSTANT VARCHAR2(50) := 'process_batch_record()';
5774: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
5775: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
5776: