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.OKC_CREATE_PO_FROM_K_PVT dependencies on PO_HEADERS_INTERFACE

Line 90: ,po_headers_interface_s.NEXTVAL po_interface_header_id

86: CURSOR c_chr (b_chr_id NUMBER) IS SELECT
87: authoring_org_id
88: ,currency_code
89: ,date_signed approved_date
90: ,po_headers_interface_s.NEXTVAL po_interface_header_id
91: ,DECODE(contract_number_modifier, null,
92: contract_number,
93: contract_number || ' - ' || contract_number_modifier)
94: contract_number_print -- used to form the

Line 167: -- po_headers_interface table

163: );
164:
165: -------------------------------------------------------------------------
166: -- po_header_rec_type holds the values that will be inserted in
167: -- po_headers_interface table
168: -- interface_header_id - Interface header unique identifier
169: -- document_type_code - Document type to be created. In our case Standard PO
170: -- document_num - number used to uniquely identify the PO in forms and reports
171: -- po_header_id - primary key in po_headers_all table

Line 176: interface_header_id po_headers_interface.interface_header_id%type,

172: -- agent_id - buyer id
173: -------------------------------------------------------------------------
174:
175: TYPE po_header_rec_type IS RECORD(
176: interface_header_id po_headers_interface.interface_header_id%type,
177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,

Line 178: document_type_code po_headers_interface.document_type_code%type,

174:
175: TYPE po_header_rec_type IS RECORD(
176: interface_header_id po_headers_interface.interface_header_id%type,
177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,

Line 179: document_num po_headers_interface.document_num%type,

175: TYPE po_header_rec_type IS RECORD(
176: interface_header_id po_headers_interface.interface_header_id%type,
177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,

Line 180: po_header_id po_headers_interface.po_header_id%type,

176: interface_header_id po_headers_interface.interface_header_id%type,
177: org_id okc_k_headers_b.authoring_org_id%type,
178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,
184: rate okc_conversion_attribs_v.conversion_rate%type,

Line 220: interface_header_id po_headers_interface.interface_header_id%type,

216: list_price_per_unit okc_k_lines_b.price_unit%type,
217: need_by_date okc_k_lines_b.start_date%type,
218: interface_line_id po_lines_interface.interface_line_id%type,
219: po_line_id po_lines_interface.po_line_id%type,
220: interface_header_id po_headers_interface.interface_header_id%type,
221: ship_to_organization_id okc_rules_b.object1_id1%type,
222: ship_to_location_id okc_rules_b.object1_id1%type,
223: terms_id okc_rules_b.object1_id1%type,
224: freight_terms okc_rules_b.object1_id1%type

Line 235: interface_header_id po_headers_interface.interface_header_id%type,

231: -- interface_line_id - Unit price for the line
232: -------------------------------------------------------------------------
233:
234: TYPE po_distributions_rec_type IS RECORD(
235: interface_header_id po_headers_interface.interface_header_id%type,
236: interface_line_id po_lines_interface.interface_line_id%type,
237: interface_distribution_id po_distributions_interface.interface_distribution_id%type,
238: org_id okc_k_headers_b.authoring_org_id%type,
239: quantity_ordered okc_k_items.number_of_items%type,

Line 1296: INSERT INTO po_headers_interface

1292:
1293: my_debug('1060: po_header_id : ' || l_po_header_id,2);
1294: x_po_header_id := l_po_header_id;
1295:
1296: INSERT INTO po_headers_interface
1297: (
1298: batch_id,
1299: interface_header_id,
1300: interface_source_code,

Line 1869: FROM po_headers_interface;

1865: -- hence the nvl
1866:
1867: SELECT NVL(MAX(batch_id),0) + 1
1868: INTO l_batch_id
1869: FROM po_headers_interface;
1870:
1871: my_debug('1760: Batch Id: ' || l_batch_id, 4);
1872:
1873: my_debug('1760: Contract Id: ' || p_chr_id, 4);