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 2902: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov

2898: select pht.line_number,pht.ship_from_location_code
2899: from pos_exasn_headers pht
2900: where pht.ship_from_location_code is not null
2901: and not exists (
2902: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov
2903: where ps.party_site_id = psu.party_site_id
2904: and psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2905: and ps.party_id = pov.party_id
2906: and pov.vendor_id= pht.vendor_id

Line 4139: hz_party_sites ps

4135: pht.ship_from_location_code,
4136: ps.location_id as ship_from_location_id
4137: from pos_exasn_headers pht,
4138: pos_exasn_lines plt,
4139: hz_party_sites ps
4140: where pht.header_id = plt.header_id
4141: and pht.ship_from_location_code is not null
4142: and ps.party_site_number = pht.ship_from_location_code||'|'||pht.vendor_id
4143: order by pht.header_id;

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

4151: l_header_id pos_exasn_headers.header_id%type;
4152: l_line_id pos_exasn_lines.po_line_id%type;
4153: l_line_location_id pos_exasn_lines.po_line_location_id%type;
4154: l_ship_from_location_code pos_exasn_headers.ship_from_location_code%type;
4155: --l_ship_from_location_id hz_party_sites.location_id%type;
4156: l_ship_from_location_id number;
4157: l_err_tbl po_tbl_varchar2000 ;
4158:
4159: