APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on PO_VENDORS

Line 257: FROM wsh_locations wl, po_vendors po, hz_relationships rel,

253: SELECT hp.party_name Company_Name,
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

Line 267: AND rel.subject_table_name = 'PO_VENDORS'

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'
270: ORDER BY cdate;
271:

Line 403: FROM wsh_locations wl, po_vendors po, hz_relationships rel,

399: SELECT hp.party_name Company_Name,
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

Line 414: AND rel.subject_table_name = 'PO_VENDORS'

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'
417: ORDER BY locid, cdate;
418: