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 JAI_CMN_TAXES_ALL

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

850: ,nvl(jcta.vat_flag,'N') VAT_FLAG
851: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
852: FROM
853: JAI_PO_TAXES jpt
854: , JAI_CMN_TAXES_ALL jcta --Added by Eric for Inclusive Tax
855: -- WHERE line_focus_id = focus_id
856: WHERE line_location_id = p_line_location_id -- 3096578
857: AND NVL(UPPER(jpt.tax_type), 'A')
858: NOT IN( 'TDS'

Line 893: , jai_cmn_taxes_all jcta

889: ,nvl(jcta.adhoc_flag,'N') adhoc_flag
890: FROM
891: jai_retro_tax_changes jrl
892: , jai_retro_line_changes jrlc
893: , jai_cmn_taxes_all jcta
894: WHERE jrlc.line_location_id = p_line_location_id
895: AND jrlc.line_change_id = jrl.line_change_id
896: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
897: FROM jai_retro_line_changes

Line 932: FROM JAI_CMN_TAXES_ALL

928: adhoc_flag, -- added by aparajita on 23/01/2003 for bug # 2694011
929: nvl(tax_rate,-1) tax_rate, --Modified by kunkumar for bug 5593895
930: tax_type,
931: NVL(rounding_factor,0) rounding_factor /* added by vumaasha for bug 6761425 */
932: FROM JAI_CMN_TAXES_ALL
933: WHERE tax_id = t_id;
934:
935: CURSOR c_inv(inv_id NUMBER) IS
936: SELECT batch_id,source

Line 1037: , jai_cmn_taxes_all jcta

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
1040: AND rt.transaction_id = tran_id
1041: AND jrl.vendor_id = ven_id

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

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
1086: AND rt.transaction_id = tran_id
1087: AND jrl.vendor_id = ven_id

Line 1120: , jai_cmn_taxes_all jcta

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
1122: AND jrlc.line_change_id = jrl.line_change_id
1123: AND jrlc.doc_version_number = (SELECT max(doc_version_number)
1124: FROM jai_retro_line_changes

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

1163: where currency_code = cp_currency_code;
1164:
1165: -- ends here additions by ssumaith -bug# 3127834
1166: --Added by kunkumar for porting 4454499
1167: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
1168: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
1169: select NVL(rounding_factor,0) -- for bug 13954092 by anupgupt
1170: from jai_cmn_taxes_all
1171: where tax_id = cp_tax_id ;

Line 1170: from jai_cmn_taxes_all

1166: --Added by kunkumar for porting 4454499
1167: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
1168: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
1169: select NVL(rounding_factor,0) -- for bug 13954092 by anupgupt
1170: from jai_cmn_taxes_all
1171: where tax_id = cp_tax_id ;
1172:
1173: /*Bug 8866084 - Added cursor to fetch Source of Invoice*/
1174: cursor c_get_ap_invoice_src (p_inv_id NUMBER)

Line 1183: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;

1179:
1180: ln_source VARCHAR2(50);
1181:
1182: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
1183: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
1184: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
1185: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
1186: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
1187: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 1559: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct

1555: cursor c_get_orig_tax_line
1556: (p_orig_invoice_id number, p_orig_invoice_dist_id number, p_tax_id number) is
1557: -- 5763527 , Added SUM as there can be two tax lines against the same tax_id because of partialy recoverable taxes
1558: select sum(jam.tax_amount) tax_amount-- project costing fwd porting
1559: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct
1560: where p_orig_invoice_id = p_orig_invoice_id
1561: and parent_invoice_distribution_id = p_orig_invoice_dist_id
1562: and jam.tax_id = p_tax_id
1563: --start additions for bug#10167393

Line 1650: stform_type(JAI_CMN_TAXES_ALL) is not null.

1646: 2. 29-mar-01 Subramanyam S.K added modifications for STForm
1647: Tracking at AP level. Insert statments for JA_in_po_st_forms_hdr
1648: and ja_in_po_st_forms_dtl after validating whether
1649: the tax line is Sales Tax or CST and for these taxes
1650: stform_type(JAI_CMN_TAXES_ALL) is not null.
1651:
1652: 3. 20-apr-01 Modifications done by Ajay Sharma for correct calculation
1653: of taxes and invoice amount at the time of RCV_MATCHING
1654:

Line 3409: FROM jai_cmn_taxes_all

3405: DECLARE
3406: CURSOR c_tax_account_id -- tax_account_id of tax_id and tax type Other
3407: IS
3408: SELECT tax_account_id
3409: FROM jai_cmn_taxes_all
3410: WHERE tax_id = i.tax_id
3411: AND tax_type = 'Other';
3412:
3413: v_tax_account_id jai_cmn_taxes_all.tax_account_id%type := NULL;

Line 3413: v_tax_account_id jai_cmn_taxes_all.tax_account_id%type := NULL;

3409: FROM jai_cmn_taxes_all
3410: WHERE tax_id = i.tax_id
3411: AND tax_type = 'Other';
3412:
3413: v_tax_account_id jai_cmn_taxes_all.tax_account_id%type := NULL;
3414: BEGIN
3415: OPEN c_tax_account_id;
3416: FETCH c_tax_account_id INTO v_tax_account_id;
3417: CLOSE c_tax_account_id;

Line 7326: FROM JAI_CMN_TAXES_ALL

7322: CURSOR c_tax(t_id NUMBER) IS
7323: SELECT tax_name, tax_account_id, mod_cr_percentage, tax_type,
7324: NVL(rounding_factor,0) rounding_factor /* added by vumaasha for bug 6761425 */
7325: -- bug 3051832, mod_cr_percentage added by aparajita on 10/10/2002 for bug # 2616100
7326: FROM JAI_CMN_TAXES_ALL
7327: WHERE tax_id = t_id;
7328:
7329: CURSOR c_inv(inv_id NUMBER) IS
7330: SELECT batch_id,source

Line 7393: , jai_cmn_taxes_all jcta

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
7396: AND rt.transaction_id = tran_id
7397: AND jrl.vendor_id = ven_id

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

7427: , jpt.tax_line_no --Added by kunkumar for bug#5593895
7428: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7429: FROM
7430: jai_po_taxes jpt
7431: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
7432: -- WHERE line_focus_id = focus_id
7433: WHERE jpt.line_location_id = p_line_location_id -- 3096578
7434: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
7435: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',

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

7455: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7456: FROM
7457: jai_cmn_lines lines
7458: , jai_cmn_document_Taxes taxes
7459: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
7460: WHERE lines.cmn_line_id = taxes.source_doc_line_id
7461: AND taxes.source_doc_type = 'ASBN'
7462: AND lines.po_line_location_id = p_line_location_id
7463: AND lines.shipment_number = cp_shipment_num

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

7609: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
7610: and attribute_code = cp_tax_type;
7611:
7612: /*Added by kunkumar for bug#5593895*/
7613: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
7614: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
7615: select NVL(rounding_factor,0) -- for bug 13954092 by anupgupt
7616: from jai_cmn_taxes_all
7617: where tax_id = cp_tax_id ;

Line 7616: from jai_cmn_taxes_all

7612: /*Added by kunkumar for bug#5593895*/
7613: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is
7614: --select NVL(rounding_factor,-1) -- for bug 13954092 by anupgupt
7615: select NVL(rounding_factor,0) -- for bug 13954092 by anupgupt
7616: from jai_cmn_taxes_all
7617: where tax_id = cp_tax_id ;
7618: /*End, Added by kunkumar for bug#5593895*/
7619:
7620: r_rcv_transactions c_rcv_transactions%rowtype;

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

7632: r_vat_regimes c_jai_regimes%rowtype;
7633: r_vat_regime_tax_type c_regime_tax_type%rowtype;
7634:
7635: ln_base_amount number ; --Added by kunkumar for bug#5593895
7636: ln_tax_precision JAI_CMN_TAXES_ALL.rounding_factor%type;--Added by kunkumar for bug#5593895
7637:
7638: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
7639:
7640: v_total_tax_in_payment number;