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_AR_TRX_TAX_LINES

Line 343: JAI_AR_TRX_TAX_LINES jcttl,

339: SELECT
340: regime_id ,
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

Line 1869: from JAI_AR_TRX_TAX_LINES jattl

1865: FROM JAI_AR_TRX_INS_LINES_T jatilt
1866: WHERE customer_trx_id = cp_customer_trx_id
1867: AND link_to_cust_trx_line_id = NVL(cp_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1868: AND EXISTS (select '1'
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

Line 3235: from JAI_AR_TRX_TAX_LINES jattl

3231: CURSOR count_cur IS
3232: SELECT count(customer_trx_line_id) FROM JAI_AR_TRX_INS_LINES_T jatilt
3233: WHERE customer_trx_id = P_CUSTOMER_TRX_ID
3234: AND EXISTS (select '1'
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

Line 3259: from JAI_AR_TRX_TAX_LINES jattl

3255: FROM JAI_AR_TRX_INS_LINES_T jatilt
3256: WHERE customer_trx_id = P_CUSTOMER_TRX_ID and
3257: link_to_cust_trx_line_id = p_link_line_id
3258: AND EXISTS (select '1'
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

Line 3285: from JAI_AR_TRX_TAX_LINES jattl

3281: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
3282: WHERE CUSTOMER_TRX_LINE_ID IN (SELECT LINK_TO_CUST_TRX_LINE_ID FROM JAI_AR_TRX_INS_LINES_T jatilt
3283: WHERE customer_trx_id = P_CUSTOMER_TRX_ID
3284: AND EXISTS (select '1'
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

Line 3306: from JAI_AR_TRX_TAX_LINES jattl

3302: SELECT LINK_TO_CUST_TRX_LINE_ID,ERROR_FLAG --added the error_flag condition to process the records,which got stuck up
3303: FROM JAI_AR_TRX_INS_LINES_T jatilt
3304: WHERE customer_trx_id = P_CUSTOMER_TRX_ID AND LINK_TO_CUST_TRX_LINE_ID = p_link_line_id
3305: AND EXISTS (select '1'
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

Line 3323: from JAI_AR_TRX_TAX_LINES jattl

3319: AND C.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
3320: AND A.ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class)
3321: AND A.CUSTOMER_TRX_LINE_ID = C.CUSTOMER_TRX_LINE_ID
3322: AND EXISTS (select '1'
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

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 3426: FROM jai_ar_trx_tax_lines

3422: CURSOR cur_chk_jai_tax_dtls ( cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
3423: cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE)
3424: IS
3425: SELECT 1
3426: FROM jai_ar_trx_tax_lines
3427: WHERE customer_trx_line_id = cp_customer_trx_line_id
3428: AND link_to_cust_trx_line_id = cp_link_to_cust_trx_line_id;
3429: ln_tax_line_exists NUMBER; --added for bug#8476512
3430:

Line 4359: from JAI_AR_TRX_TAX_LINES jattl

4355: DELETE JAI_AR_TRX_INS_LINES_T jatilt
4356: WHERE customer_trx_id = P_CUSTOMER_TRX_ID and
4357: link_to_cust_trx_line_id = p_link_line_id
4358: AND EXISTS (select '1'
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

Line 4682: , jai_ar_trx_tax_lines a

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
4686: customer_trx_line_id

Line 4761: , jai_ar_trx_tax_lines a

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
4765: (SELECT rctl.customer_trx_line_id