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 AP_INVOICE_DISTRIBUTIONS_ALL

Line 124: ap_invoice_distributions_all aid

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
128: AND aid.posted_flag = 'Y'

Line 183: ap_invoice_distributions_all aid,

179: line.match_type,
180: aid.accounting_date accounting_date
181: FROM ap_invoices_all apa,
182: ap_invoice_lines_all line,
183: ap_invoice_distributions_all aid,
184: po_line_locations_all po
185: WHERE
186: apa.invoice_id = line.invoice_id
187: AND aid.invoice_id = apa.invoice_id

Line 234: ap_invoice_distributions_all aid,

230: aid.accounting_date accounting_date
231: FROM ap_invoices_all apa,
232: ap_invoice_lines_all line,
233: jai_rcv_transactions rcv,
234: ap_invoice_distributions_all aid,
235: po_line_locations_all plla,--Added by qiong for bug 13435306
236: rcv_shipment_lines cl --Added by qiong for bug 13435306
237: WHERE
238: line.invoice_id = apa.invoice_id

Line 353: ,ap_invoice_distributions_all aida

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
357: AND jail.parent_invoice_line_number = cp_line_num

Line 372: ,ap_invoice_distributions_all aida

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
376: AND jail.invoice_id = aida.invoice_id

Line 392: ,ap_invoice_distributions_all aida

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
396: AND jcdt_st.parent_invoice_line_number = cp_line_num

Line 411: ,ap_invoice_distributions_all aida

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
415: AND jcdt_st.parent_invoice_line_number = cp_line_num