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 145: vendor_id po_vendors.vendor_id%TYPE,

141: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,
142: invoice_amount ap_invoices_interface.invoice_amount%TYPE,
143: invoice_id ap_invoices_interface.invoice_id%TYPE,
144: invoice_num ap_invoices_interface.invoice_num%TYPE,
145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
148: po_header_id po_headers.po_header_id%TYPE,
149: po_release_id po_releases.po_release_id%TYPE,

Line 195: PO_VENDORS pv,

191: DECODE(poll.taxable_flag, 'Y', poll.tax_code_id, NULL) TAX_CODE_ID,
192: poh.org_id ORG_ID,
193: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
194: FROM
195: PO_VENDORS pv,
196: PO_VENDOR_SITES pvs,
197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,

Line 258: PO_VENDORS pv,

254: DECODE(poll.taxable_flag, 'Y', poll.tax_code_id, NULL) TAX_CODE_ID,
255: por.org_id ORG_ID,
256: poll.unit_meas_lookup_code UNIT_MEAS_LOOKUP_CODE --5100177
257: FROM
258: PO_VENDORS pv,
259: PO_VENDOR_SITES pvs,
260: PO_VENDOR_SITES pvs2,
261: PO_HEADERS poh,
262: PO_RELEASES por,