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 2484: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b

2480: CURSOR check_rma_ref IS
2481: SELECT 1 from JAI_OM_OE_RMA_LINES
2482: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
2483: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
2484: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
2485: Where a.tax_id = b.tax_id
2486: AND b.tax_type = jai_constants.tax_type_freight );
2487:
2488: --added 12-Mar-2002

Line 2490: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

2486: AND b.tax_type = jai_constants.tax_type_freight );
2487:
2488: --added 12-Mar-2002
2489: CURSOR tax_type IS SELECT b.tax_type t_type,a.customer_trx_line_id line_id
2490: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
2491: WHERE link_to_cust_trx_line_id = p_link_line_id
2492: and A.tax_id = B.tax_id;
2493:
2494: CURSOR get_reason IS

Line 3384: jai_cmn_taxes_all

3380: tax_account_id
3381: INTO
3382: ln_tax_def_acc_id
3383: FROM
3384: jai_cmn_taxes_all
3385: WHERE tax_id = pn_tax_id
3386: AND org_id = pn_org_id;
3387: EXCEPTION
3388: WHEN OTHERS THEN

Line 3492: jai_cmn_taxes_all b

3488: a.tax_id tax_id
3489: , b.tax_type tax_type
3490: , SUM(a.tax_amount) tax_amount
3491: FROM
3492: jai_cmn_taxes_all b
3493: , jai_ar_trx_tax_lines a
3494: WHERE a.tax_id = b.tax_id
3495: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
3496: AND a.link_to_cust_trx_line_id IN (SELECT