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_COMP_CONSTRAINT_UTIL dependencies on PO_VENDORS

Line 62: po_vendors po,

58:
59: CURSOR c_get_sup_name(c_object_value_num IN NUMBER) IS
60: select hp.party_name
61: from hz_parties hp,
62: po_vendors po,
63: hz_relationships rel
64: where hp.party_id = c_object_value_num
65: AND rel.relationship_type = 'POS_VENDOR_PARTY'
66: and rel.object_id = hp.party_id

Line 69: and rel.subject_table_name = 'PO_VENDORS'

65: AND rel.relationship_type = 'POS_VENDOR_PARTY'
66: and rel.object_id = hp.party_id
67: and rel.object_table_name = 'HZ_PARTIES'
68: and rel.object_type = 'ORGANIZATION'
69: and rel.subject_table_name = 'PO_VENDORS'
70: and rel.subject_id = po.vendor_id
71: and rel.subject_type = 'POS_VENDOR';
72:
73: CURSOR c_get_fac_comp(c_location_id IN NUMBER) IS

Line 134: po_vendors po,

130: 'SUPPLIER' company_type,
131: nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
132: nvl(flp.description,wl.ui_location_code) description
133: FROM hz_parties hp ,
134: po_vendors po,
135: hz_relationships rel,
136: hz_party_sites hps,
137: wsh_locations wl,
138: fte_location_parameters flp

Line 144: and rel.subject_table_name = 'PO_VENDORS'

140: AND rel.relationship_type = 'POS_VENDOR_PARTY'
141: and rel.object_id = hp.party_id
142: and rel.object_table_name = 'HZ_PARTIES'
143: and rel.object_type = 'ORGANIZATION'
144: and rel.subject_table_name = 'PO_VENDORS'
145: and rel.subject_id = po.vendor_id
146: and rel.subject_type = 'POS_VENDOR'
147: AND hps.location_id = wl.source_location_id
148: AND wl.location_source_code = 'HZ'

Line 459: po_vendors po,

455: select hp.party_id company_id, hp.party_name company_name,
456: hp.party_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
457: site, 'SUPPLIER' company_type
458: FROM hz_parties hp ,
459: po_vendors po,
460: hz_relationships rel,
461: hz_party_sites hps,
462: wsh_locations wl
463: where wl.source_location_id=hps.location_id

Line 469: and rel.subject_table_name = 'PO_VENDORS'

465: AND rel.relationship_type = 'POS_VENDOR_PARTY'
466: and rel.object_id = hp.party_id
467: and rel.object_table_name = 'HZ_PARTIES'
468: and rel.object_type = 'ORGANIZATION'
469: and rel.subject_table_name = 'PO_VENDORS'
470: and rel.subject_id = po.vendor_id
471: and rel.subject_type = 'POS_VENDOR'
472: and wl.location_source_code='HZ'
473: and hp.status='A'