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_INTERFACE_S2 dependencies on PO_HEADERS_ALL

Line 88: FROM po_headers_all PH

84: SELECT PH.po_header_id,
85: PH.type_lookup_code
86: INTO x_source_header_id,
87: x_src_document_type
88: FROM po_headers_all PH
89: WHERE PH.po_header_id = x_source_header_id
90: AND PH.type_lookup_code = 'CONTRACT'
91: AND PH.vendor_id = x_vendor_id
92: AND ((PH.global_agreement_flag = 'Y'

Line 110: FROM po_headers_all ph,

106: SELECT pl.po_line_id,
107: ph.type_lookup_code --
108: INTO x_source_line_id,
109: x_src_document_type --
110: FROM po_headers_all ph,
111: po_lines_all pl
112: WHERE ph.po_header_id = pl.po_header_id
113: AND ph.vendor_id = x_vendor_id
114: AND ph.currency_code = x_currency --

Line 179: From po_headers_all

175: p_add_to_ship_via_lookup_code ,
176: p_add_to_fob_lookup_code ,
177: p_add_to_freight_lookup_code,
178: x_add_to_shipping_control --
179: From po_headers_all
180: Where po_header_id = p_add_to_doc_id;
181:
182: EXCEPTION
183: when others then

Line 263: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE; -- <2748409>

259: l_freight_lookup_code po_headers.freight_terms_lookup_code%TYPE;
260: l_supplier_note po_headers.note_to_vendor%TYPE;
261: l_receiver_note po_headers.note_to_receiver%TYPE;
262:
263: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE; -- <2748409>
264: l_pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE; -- <2748409>
265: l_bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE; -- <2748409>
266: l_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE; -- <2748409>
267:

Line 264: l_pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE; -- <2748409>

260: l_supplier_note po_headers.note_to_vendor%TYPE;
261: l_receiver_note po_headers.note_to_receiver%TYPE;
262:
263: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE; -- <2748409>
264: l_pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE; -- <2748409>
265: l_bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE; -- <2748409>
266: l_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE; -- <2748409>
267:
268: --

Line 265: l_bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE; -- <2748409>

261: l_receiver_note po_headers.note_to_receiver%TYPE;
262:
263: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE; -- <2748409>
264: l_pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE; -- <2748409>
265: l_bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE; -- <2748409>
266: l_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE; -- <2748409>
267:
268: --
269: l_ga_count NUMBER;

Line 266: l_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE; -- <2748409>

262:
263: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE; -- <2748409>
264: l_pay_on_code PO_HEADERS_ALL.pay_on_code%TYPE; -- <2748409>
265: l_bill_to_location_id PO_HEADERS_ALL.bill_to_location_id%TYPE; -- <2748409>
266: l_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%TYPE; -- <2748409>
267:
268: --
269: l_ga_count NUMBER;
270: l_quotation_count NUMBER;

Line 275: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE; --

271: l_lc_count NUMBER;
272: l_gc_count NUMBER;
273: --
274:
275: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE; --
276: l_return_status VARCHAR2(1);
277:
278: l_api_name CONSTANT VARCHAR2(30) := 'update_terms ';
279:

Line 324: po_headers_all POSRC,

320: l_quotation_count,
321: l_lc_count,
322: l_gc_count
323: FROM po_lines POL,
324: po_headers_all POSRC,
325: po_headers_all POC
326: WHERE POL.po_header_id = p_new_po_id
327: AND POL.from_header_id = POSRC.po_header_id (+)
328: AND POL.contract_id = POC.po_header_id (+);

Line 325: po_headers_all POC

321: l_lc_count,
322: l_gc_count
323: FROM po_lines POL,
324: po_headers_all POSRC,
325: po_headers_all POC
326: WHERE POL.po_header_id = p_new_po_id
327: AND POL.from_header_id = POSRC.po_header_id (+)
328: AND POL.contract_id = POC.po_header_id (+);
329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 424: From po_headers_all

420: l_pay_on_code, -- <2748409>
421: l_bill_to_location_id, -- <2748409>
422: l_ship_to_location_id, -- <2748409>
423: l_shipping_control --
424: From po_headers_all
425: Where po_header_id = l_source_doc_id;
426: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || 'After SELECTing Terms and Conditions.' , 0);
428: END IF;

Line 432: update po_headers_all

428: END IF;
429:
430: -- Bug 3807992: Added nvl to the terms to retain existing values if the
431: -- source doc does not have terms
432: update po_headers_all
433: set terms_id = nvl(l_terms_id ,terms_id),
434: fob_lookup_code = nvl(l_fob_lookup_code,fob_lookup_code),
435: freight_terms_lookup_code = nvl(l_freight_lookup_code,freight_terms_lookup_code),
436: note_to_vendor = l_supplier_note,

Line 456: UPDATE po_headers_all

452: PO_GA_PVT.is_local_document(l_source_doc_id, 'CONTRACT') OR
453: (l_quotation_count = 1 and l_ship_to_location_id is not null)) --Bug 14553745
454: THEN
455:
456: UPDATE po_headers_all
457: SET ship_via_lookup_code = nvl(l_ship_via_lookup_code ,ship_via_lookup_code),
458: pay_on_code = nvl(l_pay_on_code ,pay_on_code ),
459: bill_to_location_id = l_bill_to_location_id ,
460: ship_to_location_id = l_ship_to_location_id

Line 528: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE := NULL;

524: p_src_doc_type IN VARCHAR2,
525: p_global_flag IN VARCHAR2,
526: x_src_doc_id OUT NOCOPY NUMBER) IS
527:
528: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE := NULL;
529: l_global_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
530:
531: BEGIN
532: IF (p_src_doc_type IN ('BLANKET', 'QUOTATION')) THEN

Line 529: l_global_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

525: p_global_flag IN VARCHAR2,
526: x_src_doc_id OUT NOCOPY NUMBER) IS
527:
528: l_src_doc_id PO_HEADERS_ALL.po_header_id%TYPE := NULL;
529: l_global_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
530:
531: BEGIN
532: IF (p_src_doc_type IN ('BLANKET', 'QUOTATION')) THEN
533: SELECT POH.po_header_id

Line 536: po_headers_all POH

532: IF (p_src_doc_type IN ('BLANKET', 'QUOTATION')) THEN
533: SELECT POH.po_header_id
534: INTO x_src_doc_id
535: FROM po_lines POL,
536: po_headers_all POH
537: WHERE POL.po_header_id = p_po_header_id
538: AND POH.po_header_id = POL.from_header_id
539: AND POH.type_lookup_code = p_src_doc_type
540: AND NVL(POH.global_agreement_flag, 'N') = p_global_flag

Line 548: po_headers_all POH

544:
545: SELECT POH.po_header_id
546: INTO x_src_doc_id
547: FROM po_lines POL,
548: po_headers_all POH
549: WHERE POL.po_header_id = p_po_header_id
550: AND POH.po_header_id = POL.contract_id
551: AND NVL(POH.global_agreement_flag, 'N') = p_global_flag
552: AND ROWNUM = 1;