DBA Data[Home] [Help]

APPS.FV_IPAC_DISBURSEMENT_PKG dependencies on PO_VENDORS

Line 158: --* : po_vendors SELECT *--

154: --* : mo_global.get_current_org_id *--
155: --* : mo_utils.get_ledger_info *--
156: --* : fnd_date.canonical_to_date *--
157: --* Tables Used : ap_invoices SELECT *--
158: --* : po_vendors SELECT *--
159: --* : fv_operating_units SELECT *--
160: --* : fv_interagency_funds SELECT *--
161: --* Logic : *--
162: --****************************************************************************************--

Line 184: FROM ap_invoices ai , po_vendors pv

180: ai.invoice_num,
181: ai.vendor_id ,
182: pv.vendor_name,
183: ai.creation_date
184: FROM ap_invoices ai , po_vendors pv
185: WHERE ai.vendor_id = pv.vendor_id
186: AND ai.invoice_num LIKE 'IPAC%'
187: AND ai.payment_method_lookup_code = 'CLEARING'
188: AND EXISTS (SELECT 'X'