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_TCS_REP_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 1393: jai_cmn_document_taxes jdt ,

1389: acra.amount
1390: FROM
1391: ar_cash_receipts_all acra ,
1392: jai_ar_cash_receipts_all jcra ,
1393: jai_cmn_document_taxes jdt ,
1394: jai_regime_tax_types_v jrttv
1395: WHERE
1396: jcra.cash_receipt_id = acra.cash_receipt_id
1397: AND jcra.cash_receipt_id = cp_cash_receipt_id

Line 1875: jai_cmn_document_taxes jdt ,

1871: SELECT
1872: 1
1873: FROM
1874: jai_ar_cash_receipts_all jcra ,
1875: jai_cmn_document_taxes jdt ,
1876: jai_regime_tax_types_v jrttv
1877: WHERE
1878: jcra.cash_receipt_id = cp_cash_receipt_id
1879: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 2355: jai_cmn_document_taxes jdt ,

2351: jtc.tax_type ,
2352: jdt.tax_amt ,
2353: jdt.func_tax_amt
2354: FROM
2355: jai_cmn_document_taxes jdt ,
2356: JAI_CMN_TAXES_ALL jtc ,
2357: jai_regime_tax_types_v jrttv
2358: WHERE
2359: jdt.tax_id = jtc.tax_id

Line 2387: jai_cmn_document_taxes jdt ,

2383: AND jcra.confirm_flag = jai_constants.yes
2384: AND exists ( SELECT /* TCS type of taxes exist for the receipt */
2385: 1
2386: FROM
2387: jai_cmn_document_taxes jdt ,
2388: jai_regime_tax_types_v jrttv
2389: WHERE
2390: jdt.source_doc_id = jcra.cash_receipt_id
2391: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */

Line 2826: jai_cmn_document_taxes jdt ,

2822: FROM
2823: ar_cash_receipts_all acra ,
2824: ar_payment_schedules_all arps ,
2825: jai_ar_cash_receipts_all jcra ,
2826: jai_cmn_document_taxes jdt ,
2827: jai_regime_tax_types_v jrttv
2828: WHERE
2829: acra.cash_receipt_id = arps.cash_receipt_id
2830: AND acra.cash_receipt_id = jcra.cash_receipt_id

Line 4025: CURSOR cur_get_rcpt_taxes (cp_source_doc_id jai_cmn_document_taxes.SOURCE_DOC_ID%TYPE )

4021:
4022: /*****
4023: ||Get the receipt tax details
4024: *****/
4025: CURSOR cur_get_rcpt_taxes (cp_source_doc_id jai_cmn_document_taxes.SOURCE_DOC_ID%TYPE )
4026: IS
4027: SELECT
4028: jdt.tax_id ,
4029: jdt.tax_rate ,

Line 4035: jai_cmn_document_taxes jdt ,

4031: jdt.tax_amt ,
4032: jdt.func_tax_amt ,
4033: jdt.currency_code
4034: FROM
4035: jai_cmn_document_taxes jdt ,
4036: jai_regime_tax_types_v jrttv
4037: WHERE
4038: jdt.tax_type = jrttv.tax_type
4039: AND jdt.source_doc_id = cp_source_doc_id

Line 4142: pv_log_msg => ' copy TAXES From jai_cmn_document_taxes - p_source_document_id -> '||p_source_document_id

4138: ||Source is receipt
4139: */
4140: /*commented by csahoo for bug# 6401388
4141: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4142: pv_log_msg => ' copy TAXES From jai_cmn_document_taxes - p_source_document_id -> '||p_source_document_id
4143: ||', p_source_document_type -> '||p_source_document_type
4144: );*/
4145: FOR rec_cur_get_rcpt_taxes IN cur_get_rcpt_taxes (cp_source_doc_id => p_source_document_id )
4146: LOOP