eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_INVOICES_SV2 dependencies on PO_HEADERS

Line 9: po_headers.po_header_id%TYPE INDEX BY BINARY_INTEGER;

5:
6: /* Define structure for bulk processing */
7:
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:

Line 45: po_headers.currency_code%TYPE INDEX BY BINARY_INTEGER;

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:
47: TYPE currency_conv_type_tbl_type IS TABLE OF
48: po_headers.rate_type%TYPE INDEX BY BINARY_INTEGER;
49:

Line 48: po_headers.rate_type%TYPE INDEX BY BINARY_INTEGER;

44: TYPE currency_code_tbl_type IS TABLE OF
45: po_headers.currency_code%TYPE INDEX BY BINARY_INTEGER;
46:
47: TYPE currency_conv_type_tbl_type IS TABLE OF
48: po_headers.rate_type%TYPE INDEX BY BINARY_INTEGER;
49:
50: TYPE currency_conv_rate_tbl_type IS TABLE OF
51: po_headers.rate%TYPE INDEX BY BINARY_INTEGER;
52:

Line 51: po_headers.rate%TYPE INDEX BY BINARY_INTEGER;

47: TYPE currency_conv_type_tbl_type IS TABLE OF
48: po_headers.rate_type%TYPE INDEX BY BINARY_INTEGER;
49:
50: TYPE currency_conv_rate_tbl_type IS TABLE OF
51: po_headers.rate%TYPE INDEX BY BINARY_INTEGER;
52:
53: TYPE date_tbl_type IS TABLE OF
54: DATE INDEX BY BINARY_INTEGER;
55:

Line 57: po_headers.terms_id%TYPE INDEX BY BINARY_INTEGER;

53: TYPE date_tbl_type IS TABLE OF
54: DATE INDEX BY BINARY_INTEGER;
55:
56: TYPE payment_terms_id_tbl_type IS TABLE OF
57: po_headers.terms_id%TYPE INDEX BY BINARY_INTEGER;
58:
59: TYPE tax_code_id_tbl_type IS TABLE OF
60: po_line_locations.tax_code_id%TYPE INDEX BY BINARY_INTEGER;
61:

Line 66: po_headers.org_id%TYPE INDEX BY BINARY_INTEGER;

62: TYPE invoice_amount_tbl_type IS TABLE OF
63: ap_invoices_interface.invoice_amount%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE org_id_tbl_type IS TABLE OF
66: po_headers.org_id%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE invoice_line_num_tbl_type IS TABLE OF
69: ap_invoice_lines_interface.line_number%TYPE INDEX BY BINARY_INTEGER;
70:

Line 152: po_header_id po_headers.po_header_id%TYPE,

148: invoice_num ap_invoices_interface.invoice_num%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,

Line 154: currency_code po_headers.currency_code%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,
158: payment_terms_id po_headers.terms_id%TYPE,

Line 155: conversion_rate po_headers.rate%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,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,

Line 156: conversion_type po_headers.rate_type%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,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,
160: invoice_date ap_invoices_interface.invoice_date%TYPE

Line 157: conversion_date po_headers.rate_date%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,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,
160: invoice_date ap_invoices_interface.invoice_date%TYPE
161: );

Line 158: payment_terms_id po_headers.terms_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,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,
160: invoice_date ap_invoices_interface.invoice_date%TYPE
161: );
162:

Line 159: creation_date po_headers.creation_date%TYPE,

155: conversion_rate po_headers.rate%TYPE,
156: conversion_type po_headers.rate_type%TYPE,
157: conversion_date po_headers.rate_date%TYPE,
158: payment_terms_id po_headers.terms_id%TYPE,
159: creation_date po_headers.creation_date%TYPE,
160: invoice_date ap_invoices_interface.invoice_date%TYPE
161: );
162:
163: /* Cursor for fetching consumption advice */

Line 203: PO_HEADERS poh,

199: FROM
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

Line 216: AND DECODE (poh.consigned_consumption_flag, -- utilize PO_HEADERS_F1 idx

212: AND poh.po_header_id = pol.po_header_id
213: AND pol.po_line_id = poll.po_line_id
214: AND poll.line_location_id = pod.line_location_id
215: AND poh.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
216: AND DECODE (poh.consigned_consumption_flag, -- utilize PO_HEADERS_F1 idx
217: 'Y',
218: DECODE(poh.closed_code,
219: 'FINALLY CLOSED',
220: NULL,

Line 267: PO_HEADERS poh,

263: FROM
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