DBA Data[Home] [Help]

APPS.PO_INVOICES_SV2 dependencies on PO_DISTRIBUTIONS

Line 21: po_distributions.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;

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:

Line 42: po_distributions.quantity_ordered%TYPE INDEX BY BINARY_INTEGER;

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:

Line 206: PO_DISTRIBUTIONS pod

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) =

Line 271: PO_DISTRIBUTIONS pod

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) =