View: AS_ACCESS_TERRITORIES_SUM_V

Product:	AS - Sales Foundation
Description:	Territory access summary
Implementation/DBA Data:	APPS.AS_ACCESS_TERRITORIES_SUM_V

View Text

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'

Columns