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_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 332: from JAI_AR_TRX_TAX_LINES

328:
329: cursor c_vat_taxes_exist
330: is
331: select 1
332: from JAI_AR_TRX_TAX_LINES
333: where link_to_cust_trx_line_id
334: in
335: (select customer_trx_line_id
336: from JAI_AR_TRX_LINES

Line 686: JAI_AR_TRX_TAX_LINES jcttl,

682: SELECT
683: regime_id ,
684: regime_code
685: FROM
686: JAI_AR_TRX_TAX_LINES jcttl,
687: JAI_AR_TRX_LINES jctl,
688: JAI_CMN_TAXES_ALL jtc ,
689: jai_regime_tax_types_v jrttv
690: WHERE

Line 728: JAI_AR_TRX_TAX_LINES jcttl,

724: IS
725: SELECT
726: 1
727: FROM
728: JAI_AR_TRX_TAX_LINES jcttl,
729: JAI_AR_TRX_LINES jctl,
730: JAI_CMN_TAXES_ALL jtc
731: WHERE
732: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 1133: FROM JAI_AR_TRX_TAX_LINES A ,

1129: A.func_tax_amount func_amt,
1130: b.tax_type t_type,
1131: b.stform_type,
1132: A.tax_line_no
1133: FROM JAI_AR_TRX_TAX_LINES A ,
1134: JAI_CMN_TAXES_ALL B,
1135: JAI_INV_ITM_SETUPS C
1136: WHERE link_to_cust_trx_line_id = p_line_id
1137: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */

Line 1214: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b

1210: (location_id is NULL and v_location_id is NULL)); /* Modified by Ramananda for removal of SQL LITERALs */
1211:
1212: CURSOR for_modvat_tax_rate(p_cust_trx_line_id NUMBER) IS
1213: SELECT A.tax_rate
1214: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
1215: WHERE A.tax_id = b.tax_id
1216: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
1217: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';
1218:

Line 1246: JAI_AR_TRX_TAX_LINES jrtl,

1242: CURSOR c_total_Excise_amt IS
1243: SELECT nvl(sum(jrtl.func_tax_amount),0)
1244: FROM JAI_AR_TRXS jtrx,
1245: JAI_AR_TRX_LINES jtl,
1246: JAI_AR_TRX_TAX_LINES jrtl,
1247: JAI_CMN_TAXES_ALL jtc ,
1248: JAI_INV_ITM_SETUPS jmtl
1249: WHERE jrtl.tax_id = jtc.tax_id
1250: AND jtrx.customer_trx_id = jtl.customer_Trx_id

Line 1268: FROM JAI_AR_TRX_TAX_LINES jrctl ,

1264: v_total_excise_amt NUMBER :=0;
1265:
1266: CURSOR c_cess_amount is
1267: SELECT NVL(SUM(jrctl.func_tax_amount),0) tax_amount
1268: FROM JAI_AR_TRX_TAX_LINES jrctl ,
1269: JAI_CMN_TAXES_ALL jtc
1270: WHERE jtc.tax_id = jrctl.tax_id
1271: AND link_to_cust_trx_line_id IN
1272: (SELECT customer_trx_line_id

Line 1325: JAI_AR_TRX_TAX_LINES jcttl,

1321: SELECT
1322: regime_id ,
1323: regime_code
1324: FROM
1325: JAI_AR_TRX_TAX_LINES jcttl,
1326: JAI_AR_TRX_LINES jctl,
1327: JAI_CMN_TAXES_ALL jtc ,
1328: jai_regime_tax_types_v jrttv
1329: WHERE

Line 1346: JAI_AR_TRX_TAX_LINES jcttl,

1342: IS
1343: SELECT
1344: 1
1345: FROM
1346: JAI_AR_TRX_TAX_LINES jcttl,
1347: JAI_AR_TRX_LINES jctl,
1348: JAI_CMN_TAXES_ALL jtc
1349: WHERE
1350: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 1454: JAI_AR_TRX_TAX_LINES jcttl,

1450: IS
1451: SELECT regime_id ,
1452: regime_code
1453: FROM
1454: JAI_AR_TRX_TAX_LINES jcttl,
1455: JAI_AR_TRX_LINES jctl,
1456: JAI_CMN_TAXES_ALL jtc ,
1457: jai_regime_tax_types_v jrttv
1458: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id

Line 1523: JAI_AR_TRX_TAX_LINES jcttl,

1519: SELECT
1520: regime_id ,
1521: regime_code
1522: FROM
1523: JAI_AR_TRX_TAX_LINES jcttl,
1524: JAI_AR_TRX_LINES jctl,
1525: JAI_CMN_TAXES_ALL jtc ,
1526: jai_regime_tax_types_v jrttv
1527: WHERE

Line 1544: FROM JAI_AR_TRX_TAX_LINES jcttl,

1540: 'Y'
1541: FROM dual
1542: WHERE EXISTS
1543: (SELECT 1
1544: FROM JAI_AR_TRX_TAX_LINES jcttl,
1545: JAI_AR_TRX_LINES jctl,
1546: JAI_CMN_TAXES_ALL jtc
1547: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1548: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 2876: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

2872: --AND ACCOUNT_CLASS IN ('TAX','FREIGHT');
2873:
2874: CURSOR TAX_TYPE_CUR(p_customer_trx_line_id Number) IS
2875: SELECT A.tax_id taxid, A.tax_rate, A.uom uom,A.tax_amount tax_amt,b.tax_type t_type,A.customer_trx_line_id line_id , a.tax_line_no
2876: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
2877: WHERE link_to_cust_trx_line_id = p_customer_trx_line_id
2878: AND A.tax_id = B.tax_id
2879: ORDER BY 1;
2880:

Line 2948: JAI_AR_TRX_TAX_LINES jcttl,

2944: IS
2945: SELECT
2946: 1
2947: FROM
2948: JAI_AR_TRX_TAX_LINES jcttl,
2949: JAI_AR_TRX_LINES jctl,
2950: JAI_CMN_TAXES_ALL jtc
2951: WHERE
2952: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND

Line 3471: SQL STATEMENT JAI_AR_TRX_TAX_LINES MODIFY PRECEDENCE IS ADDED FROM 6 TO 10

3467: CURSOR GC_GET_REGIME_ID ADD CURSOR FOR GETTING REGIME ID FOR TCS
3468: VARIABLE LV_PROCESS_FLAG ADD VARIABLE LV_PROCESS_FLAG IS PROCESS FLAG
3469: VARIABLE LV_PROCESS_MESSAGE ADD VARIABLE LV_PROCESS_MESSAGE IS PROCESS MESSAGE RETURN BY CALLING OBJECT IN RESPONSE
3470: CURSOR TAX_INFO_CUR MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
3471: SQL STATEMENT JAI_AR_TRX_TAX_LINES MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
3472: 3. 27-Feb-2007 CSahoo for Bug 5390583, File Version 120.5 Forward Porting of 11i BUG 5357400
3473: When a change is done in the invoice currency code from the front end
3474: the change is being reflected in the JAI_AR_TRXS table.
3475: Added a IF clause for the same.

Line 3579: DELETE JAI_AR_TRX_TAX_LINES

3575: v_price_list_val := '';
3576: v_converted_rate := '';
3577: v_line_tax_amount := 0;
3578:
3579: DELETE JAI_AR_TRX_TAX_LINES
3580: WHERE LINK_TO_CUST_TRX_LINE_ID = Rec.CUSTOMER_TRX_LINE_ID;
3581:
3582: --added by peng.zheng for bug 10043656, begins
3583: -- lv_enable_gst_flag := JAI_GST_GENERAL_PKG.IS_GST_ENABLED;

Line 4076: JAI_AR_TRX_TAX_LINES jcttl,

4072: IS
4073: SELECT regime_id ,
4074: regime_code
4075: FROM
4076: JAI_AR_TRX_TAX_LINES jcttl,
4077: JAI_AR_TRX_LINES jctl,
4078: JAI_CMN_TAXES_ALL jtc ,
4079: jai_regime_tax_types_v jrttv
4080: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id

Line 4108: FROM JAI_AR_TRX_TAX_LINES jcttl,

4104: */
4105: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
4106: IS
4107: SELECT 1
4108: FROM JAI_AR_TRX_TAX_LINES jcttl,
4109: JAI_AR_TRX_LINES jctl,
4110: JAI_CMN_TAXES_ALL jtc
4111: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
4112: AND jctl.customer_trx_id = pr_new.customer_trx_id

Line 4171: JAI_AR_TRX_TAX_LINES jcttl ,

4167: jtc.tax_type ,
4168: jcttl.tax_rate
4169: FROM
4170: JAI_AR_TRX_LINES jctl ,
4171: JAI_AR_TRX_TAX_LINES jcttl ,
4172: JAI_CMN_TAXES_ALL jtc ,
4173: (
4174: SELECT jrttv1.tax_type tax_type
4175: FROM jai_regime_tax_types_v jrttv1

Line 4567: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

4563: a.precedence_1,a.precedence_2, a.precedence_3, a.precedence_4,a.precedence_5,
4564: a.precedence_6,a.precedence_7, a.precedence_8, a.precedence_9,a.precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
4565: a.tax_id, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.base_tax_amount, a.func_tax_amount,
4566: b.end_date valid_date, b.tax_type
4567: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
4568: WHERE a.link_to_cust_trx_line_id = p_parent_line_id
4569: AND a.tax_id = b.tax_id
4570: ORDER BY a.tax_line_no;
4571:

Line 4669: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,

4665: rec1.tax_amount := 0;
4666: rec1.base_tax_amount := 0;
4667: rec1.func_tax_amount := 0;
4668: END IF;
4669: INSERT INTO JAI_AR_TRX_TAX_LINES(customer_trx_line_id, link_to_cust_trx_line_id, tax_line_no,
4670: precedence_1,precedence_2, precedence_3, precedence_4,precedence_5,
4671: precedence_6,precedence_7, precedence_8, precedence_9,precedence_10, -- Date 06/12/2006 Bug 5228046 added by SACSETHI
4672: tax_id, tax_rate, qty_rate, uom,
4673: tax_amount, base_tax_amount, func_tax_amount,