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_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_CMN_TAXES_ALL

Line 194: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct

190: AND aid.invoice_line_number = line.line_number
191: AND line.match_type = 'ITEM_TO_PO'
192: AND po.line_location_id = line.po_line_location_id
193: AND EXISTS (
194: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct
195: WHERE jamit.tax_id = jct.tax_id
196: AND apa.invoice_id = jamit.invoice_id
197: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
198: )

Line 246: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct

242: AND aid.posted_flag = 'Y'
243: AND aid.invoice_line_number = line.line_number
244: AND line.rcv_transaction_id = rcv.transaction_id
245: AND EXISTS (
246: SELECT 1 FROM jai_ap_match_inv_taxes jamit, jai_cmn_taxes_all jct
247: WHERE jamit.tax_id = jct.tax_id
248: AND apa.invoice_id = jamit.invoice_id
249: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
250: )

Line 312: jai_cmn_taxes_all jcta

308: AND rt1.complete_flag = 'Y'
309: AND rctgl.account_class = 'REV'
310: AND EXISTS (SELECT 1
311: FROM jai_ar_trx_tax_lines jrtf_tax,
312: jai_cmn_taxes_all jcta
313: WHERE
314: jatl1.customer_trx_line_id = jrtf_tax.link_to_cust_trx_line_id
315: AND jcta.tax_id = jrtf_tax.tax_id
316: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')

Line 351: ,jai_cmn_taxes_all jcta

347:
348: CURSOR c_sum_all_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
349: SELECT NVL(SUM(jcdt.tax_amt),0)
350: FROM jai_cmn_document_taxes jcdt
351: ,jai_cmn_taxes_all jcta
352: ,jai_ap_invoice_lines jail
353: ,ap_invoice_distributions_all aida
354: WHERE
355: jcdt.source_doc_id = cp_invoice_id

Line 391: , jai_cmn_taxes_all jcta

387:
388: CURSOR c_sum_all_tax_amt_matched(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE, cp_match_type VARCHAR2) IS
389: SELECT NVL(sum(jcdt_st.tax_amount),0)
390: FROM jai_ap_match_inv_taxes jcdt_st
391: , jai_cmn_taxes_all jcta
392: ,ap_invoice_distributions_all aida
393: ,ap_invoice_lines_all line
394: WHERE
395: jcdt_st.invoice_id = cp_invoice_id

Line 410: , jai_cmn_taxes_all jcta

406:
407: CURSOR c_sum_rv_st_tax_amt_matched(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE, cp_match_type VARCHAR2) IS
408: SELECT sum(jcdt_st.tax_amount)
409: FROM jai_ap_match_inv_taxes jcdt_st
410: , jai_cmn_taxes_all jcta
411: ,ap_invoice_distributions_all aida
412: ,ap_invoice_lines_all line
413: WHERE
414: jcdt_st.invoice_id = cp_invoice_id

Line 473: jai_cmn_taxes_all jcta,

469: CURSOR c_ar_rc_st_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_reversal_date DATE) IS
470: SELECT jcta.mod_cr_percentage, jrtf.tax_amount
471: FROM jai_ar_trx_tax_lines jrtf,
472: jai_ar_trx_lines jatl,
473: jai_cmn_taxes_all jcta,
474: ra_cust_trx_line_gl_dist_all rctgl
475: WHERE jatl.customer_trx_id = cp_invoice_id
476: AND jatl.customer_trx_line_id = jrtf.link_to_cust_trx_line_id
477: AND rctgl.customer_trx_line_id = jatl.customer_trx_line_id