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

Line 345: JAI_CMN_TAXES_ALL jtc ,

341: regime_code
342: FROM
343: JAI_AR_TRX_TAX_LINES jcttl,
344: JAI_AR_TRX_LINES jctl,
345: JAI_CMN_TAXES_ALL jtc ,
346: jai_regime_tax_types_v jrttv
347: WHERE
348: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
349: jctl.customer_trx_id = pn_customer_trx_id AND

Line 1873: from JAI_CMN_TAXES_ALL

1869: from JAI_AR_TRX_TAX_LINES jattl
1870: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
1871: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
1872: and exists (select '1'
1873: from JAI_CMN_TAXES_ALL
1874: where jattl.tax_id = tax_id
1875: and NVL(inclusive_tax_flag,'N') = 'N'))
1876: ORDER BY link_to_cust_trx_line_id,
1877: customer_trx_line_id;

Line 3239: from JAI_CMN_TAXES_ALL

3235: from JAI_AR_TRX_TAX_LINES jattl
3236: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
3237: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
3238: and exists (select '1'
3239: from JAI_CMN_TAXES_ALL
3240: where jattl.tax_id = tax_id
3241: and NVL(inclusive_tax_flag,'N') = 'N'));
3242:
3243: CURSOR ORG_CUR IS

Line 3263: from JAI_CMN_TAXES_ALL

3259: from JAI_AR_TRX_TAX_LINES jattl
3260: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
3261: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
3262: and exists (select '1'
3263: from JAI_CMN_TAXES_ALL
3264: where jattl.tax_id = tax_id
3265: and NVL(inclusive_tax_flag,'N') = 'N'))
3266: order by CUSTOMER_TRX_LINE_ID;
3267:

Line 3289: from JAI_CMN_TAXES_ALL

3285: from JAI_AR_TRX_TAX_LINES jattl
3286: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
3287: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
3288: and exists (select '1'
3289: from JAI_CMN_TAXES_ALL
3290: where jattl.tax_id = tax_id
3291: and NVL(inclusive_tax_flag,'N') = 'N')));
3292:
3293:

Line 3310: from JAI_CMN_TAXES_ALL

3306: from JAI_AR_TRX_TAX_LINES jattl
3307: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
3308: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
3309: and exists (select '1'
3310: from JAI_CMN_TAXES_ALL
3311: where jattl.tax_id = tax_id
3312: and NVL(inclusive_tax_flag,'N') = 'N'));
3313: /*Bug 11936630*/
3314: CURSOR PREVIOUS_AMOUNT_CUR IS

Line 3327: from JAI_CMN_TAXES_ALL

3323: from JAI_AR_TRX_TAX_LINES jattl
3324: where jattl.link_to_cust_trx_line_id = c.link_to_cust_trx_line_id
3325: and jattl.customer_trx_line_id = c.customer_trx_line_id
3326: and exists (select '1'
3327: from JAI_CMN_TAXES_ALL
3328: where jattl.tax_id = tax_id
3329: and NVL(inclusive_tax_flag,'N') = 'N'));
3330:
3331:

Line 3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b

3391: CURSOR check_rma_ref IS
3392: SELECT 1 from JAI_OM_OE_RMA_LINES
3393: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
3394: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
3396: Where a.tax_id = b.tax_id
3397: AND b.tax_type = jai_constants.tax_type_freight );
3398:
3399: --added 12-Mar-2002

Line 3401: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

3397: AND b.tax_type = jai_constants.tax_type_freight );
3398:
3399: --added 12-Mar-2002
3400: CURSOR tax_type IS SELECT b.tax_type t_type,a.customer_trx_line_id line_id
3401: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
3402: WHERE link_to_cust_trx_line_id = p_link_line_id
3403: and A.tax_id = B.tax_id;
3404:
3405: CURSOR get_reason IS

Line 4363: from JAI_CMN_TAXES_ALL

4359: from JAI_AR_TRX_TAX_LINES jattl
4360: where jattl.link_to_cust_trx_line_id = jatilt.link_to_cust_trx_line_id
4361: and jattl.customer_trx_line_id = jatilt.customer_trx_line_id
4362: and exists (select '1'
4363: from JAI_CMN_TAXES_ALL
4364: where jattl.tax_id = tax_id
4365: and NVL(inclusive_tax_flag,'N') = 'Y'));
4366: ERRBUF := SQLERRM;
4367: -- retcode := 2;

Line 4499: jai_cmn_taxes_all

4495: tax_account_id
4496: INTO
4497: ln_tax_def_acc_id
4498: FROM
4499: jai_cmn_taxes_all
4500: WHERE tax_id = pn_tax_id
4501: AND org_id = pn_org_id;
4502: EXCEPTION
4503: WHEN OTHERS THEN

Line 4681: jai_cmn_taxes_all b

4677: , b.tax_type tax_type
4678: , SUM(a.tax_amount) tax_amount
4679: , nvl(b.rounding_factor,0) rounding_factor --Add by Xiao for bug#11936390, for rounding issue.
4680: FROM
4681: jai_cmn_taxes_all b
4682: , jai_ar_trx_tax_lines a
4683: WHERE a.tax_id = b.tax_id
4684: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
4685: AND a.link_to_cust_trx_line_id IN (SELECT

Line 4760: jai_cmn_taxes_all b

4756: , b.tax_type tax_type
4757: , SUM(a.tax_amount) tax_amount
4758: , nvl(b.rounding_factor,0) rounding_factor --Add by Xiao for bug#11936390, for rounding issue.
4759: FROM
4760: jai_cmn_taxes_all b
4761: , jai_ar_trx_tax_lines a
4762: WHERE a.tax_id = b.tax_id
4763: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
4764: AND a.link_to_cust_trx_line_id IN

Line 4875: FROM jai_cmn_taxes_all

4871: /*Bug 11905163 - Start*/
4872: CURSOR c_get_tax_account(p_tax_id IN NUMBER)
4873: IS
4874: SELECT tax_account_id
4875: FROM jai_cmn_taxes_all
4876: WHERE tax_id = p_tax_id;
4877: /*Bug 11905163 - End*/
4878:
4879: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, begin

Line 5054: FROM jai_cmn_taxes_all

5050: EXCEPTION
5051: WHEN NO_DATA_FOUND THEN
5052: SELECT tax_account_id
5053: INTO ln_tax_account_id
5054: FROM jai_cmn_taxes_all
5055: WHERE tax_id = inclu_tax_csr.tax_id
5056: AND org_id = pn_org_id;
5057:
5058: WHEN OTHERS THEN