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

Line 23: | VARCHAR2(240) to po_headers_all.note_to_vendor%TYPE.

19: | Added an IF conditional to display the item revision number
20: | when it is present
21: | - PO UTF8 Project - tpoon - 09/06/2002
22: | Changed the type of l_header_note_to_vendor from
23: | VARCHAR2(240) to po_headers_all.note_to_vendor%TYPE.
24: |
25: | - PO TIMEPHASED - davidng - 09/09/2002
26: | Project 1. Added start_date and end_date to cursor shipment_blanket_cursor
27: | to display effective dates at the Blanket Agreement price breaks.

Line 141: l_global_flag po_headers_all.global_agreement_flag%type;

137: l_po_line_only varchar2(2) := 'Y';
138: x_display_type varchar2(60);
139:
140: --
141: l_global_flag po_headers_all.global_agreement_flag%type;
142:
143: -- PO_WF_NOTIF_HEADER_NOTE
144: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
145:

Line 157: l_header_note_to_vendor po_headers_all.note_to_vendor%TYPE;

153:
154: /** Fix for PO UTF8 Project **/
155: -- This holds data from either po_headers.note_to_vendor or
156: -- po_releases.note_to_vendor:
157: l_header_note_to_vendor po_headers_all.note_to_vendor%TYPE;
158: -- l_header_note_to_vendor varchar2(240);
159:
160: x_pb_count number;
161:

Line 361: po_headers_all poh, -- --po_headers poh,

357: null,
358: null
359: --
360: FROM po_lines pol,
361: po_headers_all poh, -- --po_headers poh,
362: mtl_system_items_kfv msi,
363: mtl_units_of_measure_vl umvl,
364: financials_system_params_all fsp -- --financials_system_parameters fsp
365: where POL.PO_HEADER_ID = v_document_id

Line 448: from po_headers_all

444: -- show warning message to the supplier
445: if(l_document_type in ('PO', 'PA')) then
446: select authorization_status
447: into l_document_status
448: from po_headers_all
449: where po_header_id = l_document_id;
450:
451: elsif (l_document_type = 'RELEASE') then
452: /* Bug 2791859 po_releases_all should be used instead of po_releases */

Line 458: from po_headers_all

454: where po_release_id = l_document_id;
455:
456: select authorization_status
457: into l_document_status
458: from po_headers_all
459: where po_header_id = l_po_header_id;
460: end if;
461:
462: if(l_document_status is null or

Line 1071: from po_headers_all where po_header_id = l_line_loc.from_header_id;

1067: l_line_loc.from_line_id is NOT NULL)
1068: then
1069: begin
1070: select nvl(global_agreement_flag, 'N') into l_global_flag
1071: from po_headers_all where po_header_id = l_line_loc.from_header_id;
1072: exception
1073: when NO_DATA_FOUND then
1074: l_global_flag := 'N';
1075: end;

Line 2070: from po_headers_all where po_header_id = l_line_loc.from_header_id;

2066: l_line_loc.from_line_id is NOT NULL)
2067: then
2068: begin
2069: select nvl(global_agreement_flag, 'N') into l_global_flag
2070: from po_headers_all where po_header_id = l_line_loc.from_header_id;
2071: exception
2072: when NO_DATA_FOUND then
2073: l_global_flag := 'N';
2074: end;

Line 2423: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;

2419: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2420: l_bill_to_id NUMBER;
2421:
2422:
2423: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2424: l_po_revision NUMBER;
2425: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
2426:
2427: l_date_of_order VARCHAR2(80);

Line 2432: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

2428: l_buyer VARCHAR2(80);
2429: l_date_of_revision VARCHAR2(80);
2430: l_revision_buyer VARCHAR2(80);
2431:
2432: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2433: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2435: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

Line 2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;

2430: l_revision_buyer VARCHAR2(80);
2431:
2432: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2433: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2435: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2437: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2438: l_payment_terms_id NUMBER;

Line 2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

2432: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2433: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2434: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2435: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2436: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2437: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2438: l_payment_terms_id NUMBER;
2439: l_payment_terms ap_terms_val_v.name%TYPE;
2440: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;

Line 2562: from po_headers_all

2558: -- show warning message to the supplier
2559: if(l_document_type in ('PO', 'PA')) then
2560: select authorization_status
2561: into l_document_status
2562: from po_headers_all
2563: where po_header_id = l_document_id;
2564:
2565: elsif (l_document_type = 'RELEASE') then
2566:

Line 2576: from po_headers_all

2572: where po_release_id = l_document_id;
2573:
2574: select authorization_status
2575: into l_document_status
2576: from po_headers_all
2577: where po_header_id = l_po_header_id;
2578: end if;
2579:
2580: if(l_document_status is null or

Line 2609: select org_id into l_operating_unit_id from po_headers_all

2605:
2606: begin
2607:
2608: /* Need the org_id to get the operating unit name later */
2609: select org_id into l_operating_unit_id from po_headers_all
2610: where po_header_id = l_document_id;
2611:
2612: l_po_header_id := l_document_id;
2613:

Line 4168: from po_headers_all

4164:
4165: if(l_document_type in ('PO', 'PA')) then
4166: select authorization_status
4167: into l_document_status
4168: from po_headers_all
4169: where po_header_id = l_document_id;
4170:
4171: elsif (l_document_type = 'RELEASE') then
4172:

Line 4178: from po_headers_all

4174: where po_release_id = l_document_id;
4175:
4176: select authorization_status
4177: into l_document_status
4178: from po_headers_all
4179: where po_header_id = l_po_header_id;
4180: end if;
4181:
4182: if(l_document_status is null or