APPS.PO_INVOICES_SV2 dependencies on PO_RELEASES

Line 12: po_releases.po_release_id%TYPE INDEX BY BINARY_INTEGER;

8: TYPE po_header_id_tbl_type IS TABLE OF
9: po_headers.po_header_id%TYPE INDEX BY BINARY_INTEGER;
10:
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:

Line 153: po_release_id po_releases.po_release_id%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,
156: conversion_type po_headers.rate_type%TYPE,
157: conversion_date po_headers.rate_date%TYPE,

Line 268: PO_RELEASES por,

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,
271: PO_DISTRIBUTIONS pod
272: WHERE

Line 283: AND DECODE (por.consigned_consumption_flag, -- utilize PO_RELEASES_F1 idx

279: AND pol.po_line_id = poll.po_line_id
280: AND por.po_release_id = poll.po_release_id
281: AND poll.line_location_id = pod.line_location_id
282: AND por.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
283: AND DECODE (por.consigned_consumption_flag, -- utilize PO_RELEASES_F1 idx
284: 'Y',
285: DECODE(por.closed_code,
286: 'FINALLY CLOSED',
287: NULL,