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_CMN_TAXES_ALL

Line 341: from JAI_CMN_TAXES_ALL

337: where customer_trx_id = pr_new.customer_trx_id
338: )
339: and tax_id in
340: (select tax_id
341: from JAI_CMN_TAXES_ALL
342: where vat_flag = 'Y'
343: and org_id = pr_new.org_id
344: )
345: ;

Line 688: JAI_CMN_TAXES_ALL jtc ,

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
691: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
692: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 723: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )

719: /*
720: || Added by kunkumar for bug#5645003
721: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
722: */
723: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
724: IS
725: SELECT
726: 1
727: FROM

Line 730: JAI_CMN_TAXES_ALL jtc

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
733: jctl.customer_trx_id = pr_new.customer_trx_id AND
734: jcttl.tax_id = jtc.tax_id AND

Line 1134: JAI_CMN_TAXES_ALL B,

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 */
1138: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)

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 1247: JAI_CMN_TAXES_ALL jtc ,

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
1251: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id

Line 1269: JAI_CMN_TAXES_ALL jtc

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
1273: FROM JAI_AR_TRX_LINES

Line 1327: JAI_CMN_TAXES_ALL jtc ,

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
1330: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1331: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 1341: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )

1337: /*
1338: || Added by kunkumar for bug#5645003
1339: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
1340: */
1341: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
1342: IS
1343: SELECT
1344: 1
1345: FROM

Line 1348: JAI_CMN_TAXES_ALL jtc

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
1351: jctl.customer_trx_id = pr_new.customer_trx_id AND
1352: jcttl.tax_id = jtc.tax_id AND

Line 1456: JAI_CMN_TAXES_ALL jtc ,

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
1459: AND jctl.customer_trx_id = pr_new.customer_trx_id
1460: AND jcttl.tax_id = jtc.tax_id

Line 1525: JAI_CMN_TAXES_ALL jtc ,

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
1528: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1529: jctl.customer_trx_id = pr_new.customer_trx_id AND

Line 1546: JAI_CMN_TAXES_ALL jtc

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
1549: AND jcttl.tax_id = jtc.tax_id
1550: AND upper(jtc.tax_type) IN

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 2888: FROM JAI_CMN_TAXES_ALL B

2884: /* Added by Ramananda for bug#4468353 , end */
2885:
2886: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
2887: SELECT tax_account_id
2888: FROM JAI_CMN_TAXES_ALL B
2889: WHERE B.tax_id = p_tax_id ;
2890:
2891:
2892: CURSOR SO_AR_HDR_INFO IS

Line 2898: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )

2894: FROM JAI_AR_TRXS
2895: WHERE Customer_Trx_ID = v_customer_trx_id;
2896:
2897: /*Bug 8625057 - Start*/
2898: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
2899: IS
2900: SELECT regime_id, regime_code
2901: FROM jai_regime_tax_types_v jrttv
2902: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);

Line 2943: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )

2939: /*
2940: || Added by kunkumar for bug#5645003
2941: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
2942: */
2943: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )
2944: IS
2945: SELECT
2946: 1
2947: FROM

Line 2950: JAI_CMN_TAXES_ALL jtc

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
2953: jctl.customer_trx_id = pr_new.customer_trx_id AND
2954: jcttl.tax_id = jtc.tax_id AND

Line 3405: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE

3401: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
3402: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
3403:
3404: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
3405: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
3406: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
3407: )
3408: IS
3409: SELECT COUNT(1)

Line 3411: ,JAI_CMN_TAXES_ALL CODES

3407: )
3408: IS
3409: SELECT COUNT(1)
3410: FROM JAI_CMN_TAX_CTG_LINES CATL
3411: ,JAI_CMN_TAXES_ALL CODES
3412: ,JAI_REGIME_TAX_TYPES_V JRTTV
3413: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
3414: AND CATL.TAX_ID = CODES.TAX_ID
3415: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE

Line 4078: JAI_CMN_TAXES_ALL jtc ,

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
4081: AND jctl.customer_trx_id = pr_new.customer_trx_id
4082: AND jcttl.tax_id = jtc.tax_id

Line 4105: CURSOR c_chk_vat_reversal (cp_tax_type jai_cmn_taxes_all.tax_type%TYPE )

4101:
4102: /*
4103: || Check if only 'VAT REVERSAL' tax type is present in ja_in_ra_cust_trx_tax_lines
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,

Line 4110: JAI_CMN_TAXES_ALL jtc

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
4113: AND jcttl.tax_id = jtc.tax_id
4114: AND jtc.org_id = pr_new.org_id

Line 4172: JAI_CMN_TAXES_ALL jtc ,

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
4176: WHERE jrttv1.regime_code = jai_constants.vat_regime

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: