APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AP_INVOICE_LINES_ALL

Line 182: ap_invoice_lines_all line,

178: line.amount line_amount,
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

Line 232: ap_invoice_lines_all line,

228: line.amount,
229: line.match_type,
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

Line 344: FROM ap_invoice_lines_all aila

340: AND aca.check_id = aipa.check_id;
341:
342: CURSOR c_max_prepayment_date (cp_invoice_id NUMBER) IS
343: SELECT MAX(aila.accounting_date)
344: FROM ap_invoice_lines_all aila
345: WHERE aila.invoice_id = cp_invoice_id
346: AND aila.line_type_lookup_code = 'PREPAY';
347:
348: CURSOR c_sum_all_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS

Line 393: ,ap_invoice_lines_all line

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
397: AND line.invoice_id = jcdt_st.invoice_id

Line 412: ,ap_invoice_lines_all line

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
416: AND line.invoice_id = jcdt_st.invoice_id

Line 437: FROM ap_invoice_lines_all aila

433: AND apc.check_date <= cp_grace_date;
434:
435: CURSOR c_prepaid_amt(cp_invoice_id NUMBER, cp_grace_date DATE) IS
436: SELECT abs(nvl(SUM(aila.amount),0))
437: FROM ap_invoice_lines_all aila
438: WHERE aila.invoice_id = cp_invoice_id
439: AND aila.line_type_lookup_code = 'PREPAY'
440: AND aila.accounting_date <= cp_grace_date;
441: