DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_VENDORS

Line 24: po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;

20: TYPE po_distribution_id_tbl_type IS TABLE OF
21: po_distributions.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
22:
23: TYPE vendor_id_tbl_type IS TABLE OF
24: po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
25:
26: TYPE pay_on_rec_sum_code_tbl_type IS TABLE OF
27: po_vendor_sites.pay_on_receipt_summary_code%TYPE INDEX BY BINARY_INTEGER;
28:

Line 149: vendor_id po_vendors.vendor_id%TYPE,

145: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
146: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
147: invoice_id ap_invoices_interface.invoice_id%TYPE,
148: invoice_num ap_invoices_interface.invoice_num%TYPE,
149: vendor_id po_vendors.vendor_id%TYPE,
150: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
151: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
152: po_header_id po_headers.po_header_id%TYPE,
153: po_release_id po_releases.po_release_id%TYPE,

Line 200: PO_VENDORS pv,

196: DECODE(poll.taxable_flag, 'Y', poll.tax_code_id, NULL) TAX_CODE_ID,
197: poh.org_id ORG_ID,
198: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
199: FROM
200: PO_VENDORS pv,
201: PO_VENDOR_SITES pvs,
202: PO_VENDOR_SITES pvs2,
203: PO_HEADERS poh,
204: PO_LINES pol,

Line 264: PO_VENDORS pv,

260: DECODE(poll.taxable_flag, 'Y', poll.tax_code_id, NULL) TAX_CODE_ID,
261: por.org_id ORG_ID,
262: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
263: FROM
264: PO_VENDORS pv,
265: PO_VENDOR_SITES pvs,
266: PO_VENDOR_SITES pvs2,
267: PO_HEADERS poh,
268: PO_RELEASES por,