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 1096: l_vendor po_vendors.vendor_name%TYPE;

1092: l_acceptance_result varchar2(30);
1093: l_org_id number;
1094: l_document_id number;
1095: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1096: l_vendor po_vendors.vendor_name%TYPE;
1097: --l_accp_type varchar2(100);
1098: x_supp_user_name varchar2(100);
1099: x_supplier_displayname varchar2(100);
1100: l_nid number;

Line 1137: po_vendors pov,

1133: if l_document_type_code <> 'RELEASE' then
1134: select pov.vendor_name
1135: into l_vendor
1136: from
1137: po_vendors pov,
1138: po_headers poh
1139: where pov.vendor_id = poh.vendor_id
1140: and poh.po_header_id=l_document_id;
1141: else

Line 1147: po_vendors pov

1143: into l_vendor
1144: from
1145: po_releases por,
1146: po_headers_all poh, --
1147: po_vendors pov
1148: where por.po_release_id = l_document_id
1149: and por.po_header_id = poh.po_header_id
1150: and poh.vendor_id = pov.vendor_id;
1151: end if;

Line 1633: l_supplier_name po_vendors.vendor_name%TYPE;

1629: l_po_total number;
1630: l_po_currency po_headers.currency_code%TYPE;
1631: l_vendor_id number;
1632: l_vendor_site_id number;
1633: l_supplier_name po_vendors.vendor_name%TYPE;
1634: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
1635: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
1636: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
1637: l_sup_city po_vendor_sites_all.city%TYPE;

Line 1977: from po_vendors

1973: select
1974: vendor_name
1975: into
1976: l_supplier_name
1977: from po_vendors
1978: where vendor_id = l_vendor_id;
1979:
1980: select
1981: address_line1,

Line 2462: l_supplier_name po_vendors.vendor_name%TYPE;

2458: l_po_total number;
2459: l_po_currency po_headers.currency_code%TYPE;
2460: l_vendor_id number;
2461: l_vendor_site_id number;
2462: l_supplier_name po_vendors.vendor_name%TYPE;
2463: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
2464: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
2465: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
2466: l_sup_city po_vendor_sites_all.city%TYPE;

Line 2814: from po_vendors

2810: select
2811: vendor_name
2812: into
2813: l_supplier_name
2814: from po_vendors
2815: where vendor_id = l_vendor_id;
2816:
2817: select
2818: address_line1,

Line 3289: l_supplier_name po_vendors.vendor_name%TYPE;

3285: l_po_total number;
3286: l_po_currency po_headers.currency_code%TYPE;
3287: l_vendor_id number;
3288: l_vendor_site_id number;
3289: l_supplier_name po_vendors.vendor_name%TYPE;
3290: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3291: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3292: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3293: l_sup_city po_vendor_sites_all.city%TYPE;

Line 3743: from po_vendors

3739: select
3740: vendor_name
3741: into
3742: l_supplier_name
3743: from po_vendors
3744: where vendor_id = l_vendor_id;
3745:
3746: select
3747: address_line1,

Line 4361: l_supplier_name po_vendors.vendor_name%TYPE;

4357: l_po_total number;
4358: l_po_currency po_headers.currency_code%TYPE;
4359: l_vendor_id number;
4360: l_vendor_site_id number;
4361: l_supplier_name po_vendors.vendor_name%TYPE;
4362: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
4363: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
4364: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
4365: l_sup_city po_vendor_sites_all.city%TYPE;

Line 4643: from po_vendors

4639: end if;
4640: l_progress := '002';
4641: select vendor_name
4642: into l_supplier_name
4643: from po_vendors
4644: where vendor_id = l_vendor_id;
4645:
4646: select
4647: address_line1,

Line 5118: l_supplier_name po_vendors.vendor_name%TYPE;

5114: document_type IN OUT nocopy VARCHAR2)
5115: IS
5116:
5117: l_po_num po_headers_all.segment1%TYPE;
5118: l_supplier_name po_vendors.vendor_name%TYPE;
5119: l_blanket_num po_headers_all.segment1%TYPE;
5120: --l_release_num number;
5121: l_release_num po_releases_all.release_num%TYPE;
5122: l_document_header_info varchar2(2000);

Line 5218: po_vendors pv,

5214: l_currency_code,
5215: l_display_name
5216: from
5217: po_headers_all pha,
5218: po_vendors pv,
5219: PO_ALL_DOC_STYLE_LINES PDSL
5220: where pha.po_header_id = l_header_id
5221: and pha.vendor_id = pv.vendor_id
5222: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5284: po_vendors pv

5280: l_rel_currency_code
5281: from
5282: po_releases_all pra,
5283: po_headers_all pha,
5284: po_vendors pv
5285: where pra.po_release_id = l_release_id
5286: and pra.po_header_id = pha.po_header_id
5287: and pha.vendor_id = pv.vendor_id;
5288:

Line 5533: l_supplier_name po_vendors.vendor_name%TYPE;

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

Line 5590: po_vendors pv,

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

Line 5631: po_vendors pv

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

Line 5690: l_supplier_name po_vendors.vendor_name%TYPE;

5686: l_po_num po_headers_all.segment1%TYPE;
5687: l_blanket_num po_headers_all.segment1%TYPE;
5688: --l_release_num number;
5689: l_release_num po_releases_all.release_num%TYPE;
5690: l_supplier_name po_vendors.vendor_name%TYPE;
5691: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
5692: l_document_header_info varchar2(2000);
5693:
5694: l_id number;

Line 5746: po_vendors pv,

5742: l_supplier_name,
5743: l_global_agreement_flag,
5744: l_display_name
5745: from po_headers_all pha,
5746: po_vendors pv,
5747: PO_ALL_DOC_STYLE_LINES PDSL
5748: where pha.po_header_id = l_header_id
5749: and pv.vendor_id = pha.vendor_id
5750: AND NVL(PHA.STYLE_ID, 0) = PDSL.STYLE_ID (+)

Line 5787: po_vendors pv

5783: l_release_num,
5784: l_supplier_name
5785: from po_headers_all pha,
5786: po_releases_all pra,
5787: po_vendors pv
5788: where pra.po_release_id = l_release_id
5789: and pra.po_header_id = pha.po_header_id
5790: and pv.vendor_id = pha.vendor_id;
5791:

Line 6597: from po_vendors

6593: l_role_name := substr('ADHOC_SUP_CHG_RESP' || to_char(sysdate, 'JSSSSS')|| l_document_id || l_document_type, 1, 50);
6594:
6595: select vendor_name
6596: into l_role_display_name
6597: from po_vendors
6598: where vendor_id=l_vendor_id;
6599:
6600: if (l_document_type in ('PO', 'PA')) then
6601: select max(need_by_date)+180