APPS.PO_INVOICES_SV2 dependencies on PO_VENDOR_SITES

Line 27: po_vendor_sites.pay_on_receipt_summary_code%TYPE INDEX BY BINARY_INTEGER;

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:
29: TYPE vendor_site_id_tbl_type IS TABLE OF
30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
31:

Line 30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;

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:
29: TYPE vendor_site_id_tbl_type IS TABLE OF
30: po_vendor_sites.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
31:
32: TYPE item_id_tbl_type IS TABLE OF
33: PO_LINES.item_id%TYPE INDEX BY BINARY_INTEGER;
34:

Line 84: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;

80: TYPE description_tbl_type IS TABLE OF
81: ap_invoices_interface.description%TYPE INDEX BY BINARY_INTEGER;
82:
83: TYPE pay_curr_code_tbl_type IS TABLE OF
84: po_vendor_sites.payment_currency_code%TYPE INDEX BY BINARY_INTEGER;
85:
86: TYPE terms_id_tbl_type IS TABLE OF
87: ap_invoices_interface.terms_id%TYPE INDEX BY BINARY_INTEGER;
88:

Line 145: pay_curr_code po_vendor_sites.payment_currency_code%TYPE,

141: group_id group_id_tbl_type,
142: org_id org_id_tbl_type);
143:
144: TYPE curr_condition_rec_type IS RECORD (
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,

Line 150: pay_site_id po_vendor_sites.vendor_site_id%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,
154: currency_code po_headers.currency_code%TYPE,

Line 151: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%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,
154: currency_code po_headers.currency_code%TYPE,
155: conversion_rate po_headers.rate%TYPE,

Line 201: PO_VENDOR_SITES pvs,

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,
205: PO_LINE_LOCATIONS poll,

Line 202: PO_VENDOR_SITES pvs2,

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,
205: PO_LINE_LOCATIONS poll,
206: PO_DISTRIBUTIONS pod

Line 265: PO_VENDOR_SITES pvs,

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,
269: PO_LINES pol,

Line 266: PO_VENDOR_SITES pvs2,

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,
269: PO_LINES pol,
270: PO_LINE_LOCATIONS poll,