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 145: l_global_flag po_headers_all.global_agreement_flag%type;

141: l_po_line_only varchar2(2) := 'Y';
142: x_display_type varchar2(60);
143:
144: --
145: l_global_flag po_headers_all.global_agreement_flag%type;
146:
147: -- PO_WF_NOTIF_HEADER_NOTE
148: l_header_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE;
149:

Line 161: l_header_note_to_vendor po_headers_all.note_to_vendor%TYPE;

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

Line 368: po_headers_all poh, -- --po_headers poh,

364: NULL,
365: --
366: NULL --Bug 9356725
367: FROM po_lines pol,
368: po_headers_all poh, -- --po_headers poh,
369: mtl_system_items_kfv msi,
370: mtl_units_of_measure_vl umvl,
371: financials_system_params_all fsp -- --financials_system_parameters fsp
372: where POL.PO_HEADER_ID = v_document_id

Line 494: from po_headers_all

490: -- show warning message to the supplier
491: if(l_document_type in ('PO', 'PA')) then
492: select authorization_status
493: into l_document_status
494: from po_headers_all
495: where po_header_id = l_document_id;
496:
497: elsif (l_document_type = 'RELEASE') then
498: /* Bug 2791859 po_releases_all should be used instead of po_releases */

Line 504: from po_headers_all

500: where po_release_id = l_document_id;
501:
502: select authorization_status
503: into l_document_status
504: from po_headers_all
505: where po_header_id = l_po_header_id;
506: end if;
507:
508: if(l_document_status is null or

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

1216: l_line_loc.from_line_id is NOT NULL)
1217: then
1218: begin
1219: select nvl(global_agreement_flag, 'N') into l_global_flag
1220: from po_headers_all where po_header_id = l_line_loc.from_header_id;
1221: exception
1222: when NO_DATA_FOUND then
1223: l_global_flag := 'N';
1224: end;

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

2269: l_line_loc.from_line_id is NOT NULL)
2270: then
2271: begin
2272: select nvl(global_agreement_flag, 'N') into l_global_flag
2273: from po_headers_all where po_header_id = l_line_loc.from_header_id;
2274: exception
2275: when NO_DATA_FOUND then
2276: l_global_flag := 'N';
2277: end;

Line 2644: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;

2640: l_bill_to_region3 hr_locations_all.region_3%TYPE;
2641: l_bill_to_id NUMBER;
2642:
2643:
2644: l_po_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2645: l_po_revision NUMBER;
2646: l_release_num PO_RELEASES_ALL.RELEASE_NUM%TYPE;
2647:
2648: l_date_of_order VARCHAR2(80);

Line 2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;

2649: l_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2650: l_date_of_revision VARCHAR2(80);
2651: l_revision_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2652:
2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

Line 2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;

2651: l_revision_buyer per_all_people_f.full_name%TYPE; --bug 15957689
2652:
2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;

Line 2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;

2653: l_ship_via_lookup_code PO_HEADERS_ALL.ship_via_lookup_code%TYPE;
2654: l_ship_via_lookup_desc ORG_FREIGHT_TL.FREIGHT_CODE_TL%TYPE;
2655: l_fob_lookup_code PO_HEADERS_ALL.FOB_LOOKUP_CODE%TYPE;
2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;
2660: l_payment_terms ap_terms_val_v.name%TYPE;
2661: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;

Line 2824: from po_headers_all

2820: -- show warning message to the supplier
2821: if(l_document_type in ('PO', 'PA')) then
2822: select authorization_status
2823: into l_document_status
2824: from po_headers_all
2825: where po_header_id = l_document_id;
2826:
2827: elsif (l_document_type = 'RELEASE') then
2828:

Line 2838: from po_headers_all

2834: where po_release_id = l_document_id;
2835:
2836: select authorization_status
2837: into l_document_status
2838: from po_headers_all
2839: where po_header_id = l_po_header_id;
2840: end if;
2841:
2842: --

Line 2886: select org_id into l_operating_unit_id from po_headers_all

2882: begin
2883:
2884: /* Need the org_id to get the operating unit name later */
2885: /* BUG 9858430
2886: select org_id into l_operating_unit_id from po_headers_all
2887: where po_header_id = l_document_id; */
2888:
2889: l_po_header_id := l_document_id;
2890:

Line 4654: from po_headers_all

4650:
4651: if(l_document_type in ('PO', 'PA')) then
4652: select authorization_status
4653: into l_document_status
4654: from po_headers_all
4655: where po_header_id = l_document_id;
4656:
4657: elsif (l_document_type = 'RELEASE') then
4658:

Line 4664: from po_headers_all

4660: where po_release_id = l_document_id;
4661:
4662: select authorization_status
4663: into l_document_status
4664: from po_headers_all
4665: where po_header_id = l_po_header_id;
4666: end if;
4667:
4668: --