11: TYPE po_release_id_tbl_type IS TABLE OF
12: po_releases.po_release_id%TYPE INDEX BY BINARY_INTEGER;
13:
14: TYPE po_line_id_tbl_type IS TABLE OF
15: po_lines.po_line_id%TYPE INDEX BY BINARY_INTEGER;
16:
17: TYPE line_location_id_tbl_type IS TABLE OF
18: po_line_locations.line_location_id%TYPE INDEX BY BINARY_INTEGER;
19:
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:
35: TYPE item_description_tbl_type IS TABLE OF
36: PO_LINES.item_description%TYPE INDEX BY BINARY_INTEGER;
37:
32: TYPE item_id_tbl_type IS TABLE OF
33: PO_LINES.item_id%TYPE INDEX BY BINARY_INTEGER;
34:
35: TYPE item_description_tbl_type IS TABLE OF
36: PO_LINES.item_description%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE price_override_tbl_type IS TABLE OF
39: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;
40:
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
207: WHERE
208: pv.vendor_id = poh.vendor_id
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,
271: PO_DISTRIBUTIONS pod
272: WHERE
273: pv.vendor_id = poh.vendor_id