VIEW: APPS.AS_ACCESS_TERRITORIES_SUM_V

Source

View Text - Preformatted

SELECT distinct acc.access_id ,acc.territory_id ,terr.name ,null ,aslkp1.meaning from AS_TERRITORY_ACCESSES acc , JTF_TERR terr , AS_LOOKUPS aslkp1 where acc.territory_id = terr.terr_id(+) AND terr.rank = aslkp1.lookup_code(+) AND aslkp1.lookup_type(+) = 'RANK'

View Text - HTML Formatted

SELECT DISTINCT ACC.ACCESS_ID
, ACC.TERRITORY_ID
, TERR.NAME
, NULL
, ASLKP1.MEANING
FROM AS_TERRITORY_ACCESSES ACC
, JTF_TERR TERR
, AS_LOOKUPS ASLKP1
WHERE ACC.TERRITORY_ID = TERR.TERR_ID(+)
AND TERR.RANK = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'RANK'