DBA Data[Home] [Help]

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_V

Line 1848: ap_invoice_distributions_v ali

1844: UNION
1845: SELECT DISTINCT ai.invoice_id,
1846: ai.approval_status_lookup_code
1847: FROM ap_invoices_v ai,
1848: ap_invoice_distributions_v ali
1849: WHERE ali.po_number = c_po_num
1850: AND ai.invoice_id = ali.invoice_id
1851: AND ali.po_line_number = NVL(c_po_line_num,1)
1852: AND ai.invoice_amount = c_amount

Line 1859: ap_invoice_distributions_v ali1

1855: AND ai.source <> 'RECURRING INVOICE'
1856: AND ai.invoice_type_lookup_code = 'STANDARD'
1857: AND ai.invoice_date = (SELECT MIN(invoice_date)
1858: FROM ap_invoices_v ai1,
1859: ap_invoice_distributions_v ali1
1860: WHERE ali1.po_number = c_po_num
1861: AND ai1.invoice_id = ali1.invoice_id
1862: AND ali1.po_line_number = NVL(c_po_line_num,1)
1863: AND ai1.invoice_amount = c_amount