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_REGIME_TAX_TYPES_V

Line 163: jai_regime_tax_types_v jrttv

159: FROM
160: JAI_OM_WSH_LINES_ALL jspl ,
161: JAI_OM_WSH_LINE_TAXES jsptl,
162: JAI_CMN_TAXES_ALL jtc ,
163: jai_regime_tax_types_v jrttv
164: WHERE
165: jspl.delivery_detail_id = jsptl.delivery_detail_id
166: AND jspl.delivery_id = p_delivery_id
167: AND jspl.delivery_detail_id = p_delivery_detail_id

Line 421: jai_regime_tax_types_v jrttv

417: jrttv.regime_id
418: FROM
419: jai_rcv_line_taxes jrtl,
420: jai_cmn_taxes_all jtc ,
421: jai_regime_tax_types_v jrttv
422: WHERE
423: jrtl.shipment_line_id = p_shipment_line_id
424: AND jrtl.tax_id = jtc.tax_id
425: AND jtc.tax_type = jrttv.tax_type

Line 767: jai_regime_tax_types_v jrttv

763: JAI_AR_TRXS jrct ,
764: JAI_AR_TRX_LINES jrctl ,
765: JAI_AR_TRX_TAX_LINES jrcttl ,
766: JAI_CMN_TAXES_ALL jtc ,
767: jai_regime_tax_types_v jrttv
768:
769: WHERE
770: jrct.customer_trx_id = jrctl.customer_trx_id
771: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 1058: jai_regime_tax_types_v jrttv

1054: FROM
1055: JAI_OM_OE_SO_LINES jsl ,
1056: JAI_OM_OE_SO_TAXES jstl ,
1057: JAI_CMN_TAXES_ALL jtc ,
1058: jai_regime_tax_types_v jrttv
1059: WHERE
1060: jsl.header_id = cp_header_id
1061: AND jsl.line_id = jstl.line_id
1062: AND jtc.tax_id = jstl.tax_id

Line 1090: jai_regime_tax_types_v jrttv

1086: 1
1087: FROM
1088: JAI_OM_OE_SO_TAXES jstl ,
1089: JAI_CMN_TAXES_ALL jtc ,
1090: jai_regime_tax_types_v jrttv
1091: WHERE
1092: jsl.line_id = jstl.line_id
1093: AND jtc.tax_id = jstl.tax_id
1094: AND jtc.tax_type = jrttv.tax_type

Line 1311: jai_regime_tax_types_v jrttv

1307: JAI_AR_TRXS jrct ,
1308: JAI_AR_TRX_LINES jrctl ,
1309: JAI_AR_TRX_TAX_LINES jrcttl ,
1310: JAI_CMN_TAXES_ALL jtc ,
1311: jai_regime_tax_types_v jrttv
1312: WHERE
1313: gl_dist.customer_trx_id = jrct.customer_trx_id
1314: AND gl_dist.account_class = jai_constants.account_class_rec
1315: AND gl_dist.latest_rec_flag = jai_constants.yes

Line 1370: jai_regime_tax_types_v jrttv

1366: 1
1367: FROM
1368: JAI_AR_TRX_TAX_LINES jrcttl ,
1369: JAI_CMN_TAXES_ALL jtc ,
1370: jai_regime_tax_types_v jrttv
1371: WHERE
1372: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
1373: AND jtc.tax_id = jrcttl.tax_id
1374: AND jtc.tax_type = jrttv.tax_type

Line 1390: jai_regime_tax_types_v jrttv

1386: FROM
1387: JAI_AR_TRX_LINES jrctl ,
1388: JAI_AR_TRX_TAX_LINES jrcttl ,
1389: JAI_CMN_TAXES_ALL jtc ,
1390: jai_regime_tax_types_v jrttv
1391: WHERE
1392: jrctl.customer_trx_id = cp_customer_trx_id
1393: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
1394: AND jrcttl.tax_id = jtc.tax_id

Line 1857: jai_regime_tax_types_v jrttv

1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,
1856: JAI_CMN_TAXES_ALL jtc ,
1857: jai_regime_tax_types_v jrttv
1858: WHERE
1859: rcta.complete_flag = jai_constants.yes
1860: AND rcta.customer_trx_id = cp_customer_trx_id
1861: AND gl_dist.customer_trx_id = rcta.customer_trx_id

Line 1909: jai_regime_tax_types_v jrttv

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
1913: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 2391: jai_regime_tax_types_v jrttv

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
2395: AND jdt.tax_type = jrttv.tax_type /* Applied to doc has got TCS type of tax*/

Line 2614: jai_regime_tax_types_v jrttv

2610: jrcttl.func_tax_amount
2611: FROM
2612: JAI_AR_TRX_TAX_LINES jrcttl ,
2613: JAI_CMN_TAXES_ALL jtc ,
2614: jai_regime_tax_types_v jrttv
2615: WHERE
2616: jrcttl.link_to_cust_trx_line_id = cp_customer_trx_line_id
2617: AND jrcttl.tax_id = jtc.tax_id
2618: AND jrttv.tax_type = jtc.tax_type

Line 2872: jai_regime_tax_types_v jrttv

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
2875: AND jtc.tax_type = jrttv.tax_type
2876: AND jdt.source_doc_id = p_acra.cash_receipt_id

Line 2903: jai_regime_tax_types_v jrttv

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' */
2907: AND jdt.tax_type = jrttv.tax_type

Line 2917: jai_regime_tax_types_v jrttv

2913: FROM
2914: JAI_AR_TRX_LINES jrctl ,
2915: JAI_AR_TRX_TAX_LINES jrcttl,
2916: JAI_CMN_TAXES_ALL jtc ,
2917: jai_regime_tax_types_v jrttv
2918: WHERE
2919: jrctl.customer_trx_id = ra.applied_customer_trx_id
2920: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
2921: AND jrcttl.tax_id = jtc.tax_id

Line 3277: jai_regime_tax_types_v jrttv

3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,
3276: JAI_CMN_TAXES_ALL jtc ,
3277: jai_regime_tax_types_v jrttv
3278: WHERE
3279: rcta.customer_trx_id = cp_applied_customer_trx_id
3280: AND rcta.complete_flag = jai_constants.yes
3281: AND rcta.customer_trx_id = gl_dist.customer_trx_id

Line 3348: jai_regime_tax_types_v jrttv

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
3352: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 3385: jai_regime_tax_types_v jrttv

3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,
3384: JAI_CMN_TAXES_ALL jtc ,
3385: jai_regime_tax_types_v jrttv
3386: WHERE
3387: rcta.complete_flag = jai_constants.yes
3388: AND trx_types.cust_trx_type_id = rcta.cust_trx_type_id
3389: AND trx_types.type = jai_constants.ar_invoice_type_cm

Line 4582: jai_regime_tax_types_v jrttv

4578: JAI_AR_TRXS jrct ,
4579: JAI_AR_TRX_LINES jrctl ,
4580: JAI_AR_TRX_TAX_LINES jrcttl ,
4581: JAI_CMN_TAXES_ALL jtc ,
4582: jai_regime_tax_types_v jrttv
4583: WHERE
4584: jrct.customer_trx_id = cp_customer_trx_id
4585: AND jrct.customer_trx_id = jrctl.customer_trx_id
4586: AND jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id

Line 4607: jai_regime_tax_types_v jrttv

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
4611: AND jrttv.regime_code = jai_constants.tcs_regime