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 149: po_release_id po_releases.po_release_id%TYPE,

145: vendor_id po_vendors.vendor_id%TYPE,
146: pay_site_id po_vendor_sites.vendor_site_id%TYPE,
147: inv_summary_code po_vendor_sites.pay_on_receipt_summary_code%TYPE,
148: po_header_id po_headers.po_header_id%TYPE,
149: po_release_id po_releases.po_release_id%TYPE,
150: currency_code po_headers.currency_code%TYPE,
151: conversion_rate po_headers.rate%TYPE,
152: conversion_type po_headers.rate_type%TYPE,
153: conversion_date po_headers.rate_date%TYPE,

Line 262: PO_RELEASES por,

258: PO_VENDORS pv,
259: PO_VENDOR_SITES pvs,
260: PO_VENDOR_SITES pvs2,
261: PO_HEADERS poh,
262: PO_RELEASES por,
263: PO_LINES pol,
264: PO_LINE_LOCATIONS poll,
265: PO_DISTRIBUTIONS pod
266: WHERE

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

273: AND pol.po_line_id = poll.po_line_id
274: AND por.po_release_id = poll.po_release_id
275: AND poll.line_location_id = pod.line_location_id
276: AND por.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
277: AND DECODE (por.consigned_consumption_flag, -- utilize PO_RELEASES_F1 idx
278: 'Y',
279: DECODE(por.closed_code,
280: 'FINALLY CLOSED',
281: NULL,