VIEW: APPS.CLN_ITEMMST_SUPPLIER_V

Source

View Text - Preformatted

SELECT haou.name NAME, hla.ece_tp_location_code SUPPLIER_PARTNRIDX from hr_all_organization_units haou, hr_locations_all hla WHERE haou.location_id = hla.location_id and haou.organization_id = (select FND_PROFILE.VALUE('ORG_ID') from dual)

View Text - HTML Formatted

SELECT HAOU.NAME NAME
, HLA.ECE_TP_LOCATION_CODE SUPPLIER_PARTNRIDX
FROM HR_ALL_ORGANIZATION_UNITS HAOU
, HR_LOCATIONS_ALL HLA
WHERE HAOU.LOCATION_ID = HLA.LOCATION_ID
AND HAOU.ORGANIZATION_ID = (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL)