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_AP_INVOICE_LINES

Line 123: jai_ap_invoice_lines jail,

119: jail.invoice_line_number,
120: jail.line_amount,
121: aid.accounting_date
122: FROM ap_invoices_all apa,
123: jai_ap_invoice_lines jail,
124: ap_invoice_distributions_all aid
125: WHERE
126: jail.invoice_id = apa.invoice_id
127: AND apa.invoice_id = aid.invoice_id

Line 352: ,jai_ap_invoice_lines jail

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
356: AND jail.invoice_id = jcdt.source_doc_id

Line 371: ,jai_ap_invoice_lines jail

367:
368: CURSOR c_sum_rv_st_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
369: SELECT sum(jcdt.tax_amt)
370: FROM jai_cmn_document_taxes jcdt
371: ,jai_ap_invoice_lines jail
372: ,ap_invoice_distributions_all aida
373: WHERE
374: jcdt.source_doc_id = cp_invoice_id
375: and jail.invoice_id = jcdt.source_doc_id