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.POS_EXCELASN_PVT dependencies on HZ_PARTY_SITES

Line 2972: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov

2968: select pht.line_number,pht.ship_from_location_code
2969: from pos_exasn_headers pht
2970: where pht.ship_from_location_code is not null
2971: and not exists (
2972: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov
2973: where ps.party_site_id = psu.party_site_id
2974: and psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2975: and ps.party_id = pov.party_id
2976: and pov.vendor_id= pht.vendor_id

Line 4213: hz_party_sites ps

4209: pht.ship_from_location_code,
4210: ps.location_id as ship_from_location_id
4211: from pos_exasn_headers pht,
4212: pos_exasn_lines plt,
4213: hz_party_sites ps
4214: where pht.header_id = plt.header_id
4215: and pht.ship_from_location_code is not null
4216: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4217: order by pht.header_id;

Line 4229: --l_ship_from_location_id hz_party_sites.location_id%type;

4225: l_header_id pos_exasn_headers.header_id%type;
4226: l_line_id pos_exasn_lines.po_line_id%type;
4227: l_line_location_id pos_exasn_lines.po_line_location_id%type;
4228: l_ship_from_location_code pos_exasn_headers.ship_from_location_code%type;
4229: --l_ship_from_location_id hz_party_sites.location_id%type;
4230: l_ship_from_location_id number;
4231: l_err_tbl po_tbl_varchar2000 ;
4232:
4233: