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 1908: jai_cmn_document_taxes jdt ,

1904: acra.amount
1905: FROM
1906: ar_cash_receipts_all acra ,
1907: jai_ar_cash_receipts_all jcra ,
1908: jai_cmn_document_taxes jdt ,
1909: jai_regime_tax_types_v jrttv
1910: WHERE
1911: jcra.cash_receipt_id = acra.cash_receipt_id
1912: AND jcra.cash_receipt_id = cp_cash_receipt_id

Line 2390: jai_cmn_document_taxes jdt ,

2386: SELECT
2387: 1
2388: FROM
2389: jai_ar_cash_receipts_all jcra ,
2390: jai_cmn_document_taxes jdt ,
2391: jai_regime_tax_types_v jrttv
2392: WHERE
2393: jcra.cash_receipt_id = cp_cash_receipt_id
2394: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 2870: jai_cmn_document_taxes jdt ,

2866: jtc.tax_type ,
2867: jdt.tax_amt ,
2868: jdt.func_tax_amt
2869: FROM
2870: jai_cmn_document_taxes jdt ,
2871: JAI_CMN_TAXES_ALL jtc ,
2872: jai_regime_tax_types_v jrttv
2873: WHERE
2874: jdt.tax_id = jtc.tax_id

Line 2902: jai_cmn_document_taxes jdt ,

2898: AND jcra.confirm_flag = jai_constants.yes
2899: AND exists ( SELECT /* TCS type of taxes exist for the receipt */
2900: 1
2901: FROM
2902: jai_cmn_document_taxes jdt ,
2903: jai_regime_tax_types_v jrttv
2904: WHERE
2905: jdt.source_doc_id = jcra.cash_receipt_id
2906: AND jdt.source_table_name = jai_constants.jai_cash_rcpts /* 'JAI_AR_CASH_RECEIPTS_ALL' */

Line 3347: jai_cmn_document_taxes jdt ,

3343: FROM
3344: ar_cash_receipts_all acra ,
3345: ar_payment_schedules_all arps ,
3346: jai_ar_cash_receipts_all jcra ,
3347: jai_cmn_document_taxes jdt ,
3348: jai_regime_tax_types_v jrttv
3349: WHERE
3350: acra.cash_receipt_id = arps.cash_receipt_id
3351: AND acra.cash_receipt_id = jcra.cash_receipt_id

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

4592:
4593: /*****
4594: ||Get the receipt tax details
4595: *****/
4596: CURSOR cur_get_rcpt_taxes (cp_source_doc_id jai_cmn_document_taxes.SOURCE_DOC_ID%TYPE )
4597: IS
4598: SELECT
4599: jdt.tax_id ,
4600: jdt.tax_rate ,

Line 4606: jai_cmn_document_taxes jdt ,

4602: jdt.tax_amt ,
4603: jdt.func_tax_amt ,
4604: jdt.currency_code
4605: FROM
4606: jai_cmn_document_taxes jdt ,
4607: jai_regime_tax_types_v jrttv
4608: WHERE
4609: jdt.tax_type = jrttv.tax_type
4610: AND jdt.source_doc_id = cp_source_doc_id

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

4709: ||Source is receipt
4710: */
4711: /*commented by csahoo for bug# 6401388
4712: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4713: pv_log_msg => ' copy TAXES From jai_cmn_document_taxes - p_source_document_id -> '||p_source_document_id
4714: ||', p_source_document_type -> '||p_source_document_type
4715: );*/
4716: FOR rec_cur_get_rcpt_taxes IN cur_get_rcpt_taxes (cp_source_doc_id => p_source_document_id )
4717: LOOP