17: TYPE line_location_id_tbl_type IS TABLE OF
18: po_line_locations.line_location_id%TYPE INDEX BY BINARY_INTEGER;
19:
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:
38: TYPE price_override_tbl_type IS TABLE OF
39: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;
40:
41: TYPE quantity_tbl_type IS TABLE OF
42: po_distributions.quantity_ordered%TYPE INDEX BY BINARY_INTEGER;
43:
44: TYPE currency_code_tbl_type IS TABLE OF
45: po_headers.currency_code%TYPE INDEX BY BINARY_INTEGER;
46:
202: PO_VENDOR_SITES pvs2,
203: PO_HEADERS poh,
204: PO_LINES pol,
205: PO_LINE_LOCATIONS poll,
206: PO_DISTRIBUTIONS pod
207: WHERE
208: pv.vendor_id = poh.vendor_id
209: AND poh.vendor_site_id = pvs.vendor_site_id
210: AND NVL(pvs.default_pay_site_id, pvs.vendor_site_id) =
267: PO_HEADERS poh,
268: PO_RELEASES por,
269: PO_LINES pol,
270: PO_LINE_LOCATIONS poll,
271: PO_DISTRIBUTIONS pod
272: WHERE
273: pv.vendor_id = poh.vendor_id
274: AND poh.vendor_site_id = pvs.vendor_site_id
275: AND NVL(pvs.default_pay_site_id, pvs.vendor_site_id) =