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 42: po_headers.currency_code%TYPE INDEX BY BINARY_INTEGER;

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:
44: TYPE currency_conv_type_tbl_type IS TABLE OF
45: po_headers.rate_type%TYPE INDEX BY BINARY_INTEGER;
46:

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

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

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

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

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

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

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

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

Line 148: po_header_id po_headers.po_header_id%TYPE,

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

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

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

Line 152: conversion_type po_headers.rate_type%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,
154: payment_terms_id po_headers.terms_id%TYPE,
155: creation_date po_headers.creation_date%TYPE,
156: invoice_date ap_invoices_interface.invoice_date%TYPE

Line 153: conversion_date po_headers.rate_date%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,
154: payment_terms_id po_headers.terms_id%TYPE,
155: creation_date po_headers.creation_date%TYPE,
156: invoice_date ap_invoices_interface.invoice_date%TYPE
157: );

Line 154: payment_terms_id po_headers.terms_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,
154: payment_terms_id po_headers.terms_id%TYPE,
155: creation_date po_headers.creation_date%TYPE,
156: invoice_date ap_invoices_interface.invoice_date%TYPE
157: );
158:

Line 155: creation_date po_headers.creation_date%TYPE,

151: conversion_rate po_headers.rate%TYPE,
152: conversion_type po_headers.rate_type%TYPE,
153: conversion_date po_headers.rate_date%TYPE,
154: payment_terms_id po_headers.terms_id%TYPE,
155: creation_date po_headers.creation_date%TYPE,
156: invoice_date ap_invoices_interface.invoice_date%TYPE
157: );
158:
159: /* Cursor for fetching consumption advice */

Line 198: PO_HEADERS poh,

194: FROM
195: PO_VENDORS pv,
196: PO_VENDOR_SITES pvs,
197: PO_VENDOR_SITES pvs2,
198: PO_HEADERS poh,
199: PO_LINES pol,
200: PO_LINE_LOCATIONS poll,
201: PO_DISTRIBUTIONS pod
202: WHERE

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

207: AND poh.po_header_id = pol.po_header_id
208: AND pol.po_line_id = poll.po_line_id
209: AND poll.line_location_id = pod.line_location_id
210: AND poh.pay_on_code IN ('RECEIPT_AND_USE', 'USE')
211: AND DECODE (poh.consigned_consumption_flag, -- utilize PO_HEADERS_F1 idx
212: 'Y',
213: DECODE(poh.closed_code,
214: 'FINALLY CLOSED',
215: NULL,

Line 261: PO_HEADERS poh,

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