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.FTE_LOCATION_PARAMETERS_PKG dependencies on HZ_PARTIES

Line 243: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,

239: SELECT hp.party_name Company_Name,
240: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
241: hps.creation_date Cdate,
242: 'CUSTOMER' Company_Type
243: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
244: hz_cust_acct_sites_all hcas
245: WHERE wl.source_location_id = p_location_id
246: AND wl.location_source_code = 'HZ'
247: AND wl.source_location_id = hps.location_id

Line 258: hz_party_sites hps, hz_parties hp

254: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
255: hps.creation_date Cdate,
256: 'SUPPLIER' Company_Type
257: FROM wsh_locations wl, po_vendors po, hz_relationships rel,
258: hz_party_sites hps, hz_parties hp
259: WHERE wl.source_location_id = p_location_id
260: AND wl.source_location_id = hps.location_id
261: AND hps.party_id = hp.party_id
262: AND hp.status='A'

Line 265: AND rel.object_table_name = 'HZ_PARTIES'

261: AND hps.party_id = hp.party_id
262: AND hp.status='A'
263: AND rel.relationship_type = 'POS_VENDOR_PARTY'
264: AND rel.object_id = hp.party_id
265: AND rel.object_table_name = 'HZ_PARTIES'
266: AND rel.object_type = 'ORGANIZATION'
267: AND rel.subject_table_name = 'PO_VENDORS'
268: AND rel.subject_id = po.vendor_id
269: AND rel.subject_type = 'POS_VENDOR'

Line 384: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,

380: wl.wsh_location_id LocId,
381: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
382: hps.creation_date Cdate,
383: 'CUSTOMER' Company_Type
384: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
385: hz_cust_acct_sites_all hcas, fte_location_parameters flp,
386: wsh_location_owners wlo
387: WHERE wl.wsh_location_id = flp.location_id(+)
388: AND wl.wsh_location_id = wlo.wsh_location_id

Line 404: hz_party_sites hps, hz_parties hp, fte_location_parameters flp

400: wl.wsh_location_id LocId,
401: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
402: hps.creation_date Cdate, 'SUPPLIER' Company_Type
403: FROM wsh_locations wl, po_vendors po, hz_relationships rel,
404: hz_party_sites hps, hz_parties hp, fte_location_parameters flp
405: WHERE wl.wsh_location_id = flp.location_id(+)
406: AND flp.location_id IS NULL
407: AND wl.source_location_id = hps.location_id
408: AND hp.status='A'

Line 412: AND rel.object_table_name = 'HZ_PARTIES'

408: AND hp.status='A'
409: AND hps.party_id = hp.party_id
410: AND rel.relationship_type = 'POS_VENDOR_PARTY'
411: AND rel.object_id = hp.party_id
412: AND rel.object_table_name = 'HZ_PARTIES'
413: AND rel.object_type = 'ORGANIZATION'
414: AND rel.subject_table_name = 'PO_VENDORS'
415: AND rel.subject_id = po.vendor_id
416: AND rel.subject_type = 'POS_VENDOR'