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 39: po_distributions.quantity_ordered%TYPE INDEX BY BINARY_INTEGER;

35: TYPE price_override_tbl_type IS TABLE OF
36: po_line_locations.price_override%TYPE INDEX BY BINARY_INTEGER;
37:
38: TYPE quantity_tbl_type IS TABLE OF
39: po_distributions.quantity_ordered%TYPE INDEX BY BINARY_INTEGER;
40:
41: TYPE currency_code_tbl_type IS TABLE OF
42: po_headers.currency_code%TYPE INDEX BY BINARY_INTEGER;
43:

Line 201: PO_DISTRIBUTIONS pod

197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,
200: PO_LINE_LOCATIONS poll,
201: PO_DISTRIBUTIONS pod
202: WHERE
203: pv.vendor_id = poh.vendor_id
204: AND poh.vendor_site_id = pvs.vendor_site_id
205: AND NVL(pvs.default_pay_site_id, pvs.vendor_site_id) =

Line 265: PO_DISTRIBUTIONS pod

261: PO_HEADERS poh,
262: PO_RELEASES por,
263: PO_LINES pol,
264: PO_LINE_LOCATIONS poll,
265: PO_DISTRIBUTIONS pod
266: WHERE
267: pv.vendor_id = poh.vendor_id
268: AND poh.vendor_site_id = pvs.vendor_site_id
269: AND NVL(pvs.default_pay_site_id, pvs.vendor_site_id) =