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_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_VENDOR_SITES_ALL

Line 3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;

3073: l_vendor_id number;
3074: l_vendor_site_id number;
3075:
3076: l_supplier_name po_vendors.vendor_name%TYPE;
3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;

Line 3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;

3074: l_vendor_site_id number;
3075:
3076: l_supplier_name po_vendors.vendor_name%TYPE;
3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;

Line 3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;

3075:
3076: l_supplier_name po_vendors.vendor_name%TYPE;
3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;

Line 3080: l_sup_city po_vendor_sites_all.city%TYPE;

3076: l_supplier_name po_vendors.vendor_name%TYPE;
3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;

Line 3081: l_sup_state po_vendor_sites_all.state%TYPE;

3077: l_sup_address_line1 po_vendor_sites_all.address_line1%TYPE;
3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;

Line 3082: l_sup_zip po_vendor_sites_all.zip%TYPE;

3078: l_sup_address_line2 po_vendor_sites_all.address_line2%TYPE;
3079: l_sup_address_line3 po_vendor_sites_all.address_line3%TYPE;
3080: l_sup_city po_vendor_sites_all.city%TYPE;
3081: l_sup_state po_vendor_sites_all.state%TYPE;
3082: l_sup_zip po_vendor_sites_all.zip%TYPE;
3083: l_order_date date;
3084: l_fob po_headers_all.fob_lookup_code%TYPE;
3085: l_carrier po_headers_all.ship_via_lookup_code%TYPE;
3086: l_ship_to_id number;

Line 3367: from po_vendor_sites_all

3363: select vendor_name into l_supplier_name from po_vendors where vendor_id = l_vendor_id;
3364: select address_line1, address_line2, address_line3, city,state,zip
3365: into l_sup_address_line1, l_sup_address_line2, l_sup_address_line3, l_sup_city,
3366: l_sup_state,l_sup_zip
3367: from po_vendor_sites_all
3368: where vendor_site_id = l_vendor_site_id;
3369:
3370: select address_line_1, address_line_2, address_line_3, town_or_city, region_1, postal_code
3371: into l_ship_addr_l1, l_ship_addr_l2, l_ship_addr_l3, l_ship_city, l_ship_state, l_ship_zip