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_CHANGEORDERWF_PVT dependencies on PO_VENDORS

Line 1001: l_vendor po_vendors.vendor_name%TYPE;

997: l_acceptance_result varchar2(30);
998: l_org_id number;
999: l_document_id number;
1000: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1001: l_vendor po_vendors.vendor_name%TYPE;
1002: --l_accp_type varchar2(100);
1003: x_supp_user_name varchar2(100);
1004: x_supplier_displayname varchar2(100);
1005: l_nid number;

Line 1042: po_vendors pov,

1038: if l_document_type_code <> 'RELEASE' then
1039: select pov.vendor_name
1040: into l_vendor
1041: from
1042: po_vendors pov,
1043: po_headers poh
1044: where pov.vendor_id = poh.vendor_id
1045: and poh.po_header_id=l_document_id;
1046: else

Line 1052: po_vendors pov

1048: into l_vendor
1049: from
1050: po_releases por,
1051: po_headers_all poh, --
1052: po_vendors pov
1053: where por.po_release_id = l_document_id
1054: and por.po_header_id = poh.po_header_id
1055: and poh.vendor_id = pov.vendor_id;
1056: end if;

Line 1492: l_supplier_name po_vendors.vendor_name%TYPE;

1488: l_po_total number;
1489: l_po_currency po_headers.currency_code%TYPE;
1490: l_vendor_id number;
1491: l_vendor_site_id number;
1492: l_supplier_name po_vendors.vendor_name%TYPE;
1493: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1494: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1495: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1496: l_sup_city po_vendor_sites_all.city%TYPE;

Line 1829: from po_vendors

1825: select
1826: vendor_name
1827: into
1828: l_supplier_name
1829: from po_vendors
1830: where vendor_id = l_vendor_id;
1831:
1832: select
1833: address_line1,

Line 2314: l_supplier_name po_vendors.vendor_name%TYPE;

2310: l_po_total number;
2311: l_po_currency po_headers.currency_code%TYPE;
2312: l_vendor_id number;
2313: l_vendor_site_id number;
2314: l_supplier_name po_vendors.vendor_name%TYPE;
2315: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2316: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2317: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2318: l_sup_city po_vendor_sites_all.city%TYPE;

Line 2662: from po_vendors

2658: select
2659: vendor_name
2660: into
2661: l_supplier_name
2662: from po_vendors
2663: where vendor_id = l_vendor_id;
2664:
2665: select
2666: address_line1,

Line 3137: l_supplier_name po_vendors.vendor_name%TYPE;

3133: l_po_total number;
3134: l_po_currency po_headers.currency_code%TYPE;
3135: l_vendor_id number;
3136: l_vendor_site_id number;
3137: l_supplier_name po_vendors.vendor_name%TYPE;
3138: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3139: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3140: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3141: l_sup_city po_vendor_sites_all.city%TYPE;

Line 3591: from po_vendors

3587: select
3588: vendor_name
3589: into
3590: l_supplier_name
3591: from po_vendors
3592: where vendor_id = l_vendor_id;
3593:
3594: select
3595: address_line1,

Line 4209: l_supplier_name po_vendors.vendor_name%TYPE;

4205: l_po_total number;
4206: l_po_currency po_headers.currency_code%TYPE;
4207: l_vendor_id number;
4208: l_vendor_site_id number;
4209: l_supplier_name po_vendors.vendor_name%TYPE;
4210: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4211: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4212: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4213: l_sup_city po_vendor_sites_all.city%TYPE;

Line 4491: from po_vendors

4487: end if;
4488: l_progress := '002';
4489: select vendor_name
4490: into l_supplier_name
4491: from po_vendors
4492: where vendor_id = l_vendor_id;
4493:
4494: select
4495: address_line1,

Line 4966: l_supplier_name po_vendors.vendor_name%TYPE;

4962: document_type IN OUT nocopy VARCHAR2)
4963: IS
4964:
4965: l_po_num po_headers_all.segment1%TYPE;
4966: l_supplier_name po_vendors.vendor_name%TYPE;
4967: l_blanket_num po_headers_all.segment1%TYPE;
4968: --l_release_num number;
4969: l_release_num po_releases_all.release_num%TYPE;
4970: l_document_header_info varchar2(2000);

Line 5066: po_vendors pv,

5062: l_currency_code,
5063: l_display_name
5064: from
5065: po_headers_all pha,
5066: po_vendors pv,
5067: PO_ALL_DOC_STYLE_LINES PDSL
5068: where pha.po_header_id = l_header_id
5069: and pha.vendor_id = pv.vendor_id
5070: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5132: po_vendors pv

5128: l_rel_currency_code
5129: from
5130: po_releases_all pra,
5131: po_headers_all pha,
5132: po_vendors pv
5133: where pra.po_release_id = l_release_id
5134: and pra.po_header_id = pha.po_header_id
5135: and pha.vendor_id = pv.vendor_id;
5136:

Line 5379: l_supplier_name po_vendors.vendor_name%TYPE;

5375: l_po_num po_headers_all.segment1%TYPE;
5376: l_blanket_num po_headers_all.segment1%TYPE;
5377: --l_release_num number;
5378: l_release_num po_releases_all.release_num%TYPE;
5379: l_supplier_name po_vendors.vendor_name%TYPE;
5380: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5381: l_document_header_info varchar2(2000);
5382:
5383: l_id number;

Line 5436: po_vendors pv,

5432: l_supplier_name,
5433: l_global_agreement_flag,
5434: l_display_name
5435: from po_headers_all pha,
5436: po_vendors pv,
5437: PO_ALL_DOC_STYLE_LINES PDSL
5438: where pha.po_header_id = l_header_id
5439: and pv.vendor_id = pha.vendor_id
5440: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5477: po_vendors pv

5473: l_release_num,
5474: l_supplier_name
5475: from po_headers_all pha,
5476: po_releases_all pra,
5477: po_vendors pv
5478: where pra.po_release_id = l_release_id
5479: and pra.po_header_id = pha.po_header_id
5480: and pv.vendor_id = pha.vendor_id;
5481:

Line 5536: l_supplier_name po_vendors.vendor_name%TYPE;

5532: l_po_num po_headers_all.segment1%TYPE;
5533: l_blanket_num po_headers_all.segment1%TYPE;
5534: --l_release_num number;
5535: l_release_num po_releases_all.release_num%TYPE;
5536: l_supplier_name po_vendors.vendor_name%TYPE;
5537: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5538: l_document_header_info varchar2(2000);
5539:
5540: l_id number;

Line 5592: po_vendors pv,

5588: l_supplier_name,
5589: l_global_agreement_flag,
5590: l_display_name
5591: from po_headers_all pha,
5592: po_vendors pv,
5593: PO_ALL_DOC_STYLE_LINES PDSL
5594: where pha.po_header_id = l_header_id
5595: and pv.vendor_id = pha.vendor_id
5596: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5633: po_vendors pv

5629: l_release_num,
5630: l_supplier_name
5631: from po_headers_all pha,
5632: po_releases_all pra,
5633: po_vendors pv
5634: where pra.po_release_id = l_release_id
5635: and pra.po_header_id = pha.po_header_id
5636: and pv.vendor_id = pha.vendor_id;
5637:

Line 6439: from po_vendors

6435: l_role_name := substr('ADHOC_SUP_CHG_RESP' || to_char(sysdate, 'JSSSSS')|| l_document_id || l_document_type, 1, 50);
6436:
6437: select vendor_name
6438: into l_role_display_name
6439: from po_vendors
6440: where vendor_id=l_vendor_id;
6441:
6442: if (l_document_type in ('PO', 'PA')) then
6443: select max(need_by_date)+180