[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Territory types view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TERRTYPE.ROWID
, TERRTYPE.TERRITORY_TYPE_ID
, TERRTYPE.NAME
, TERRTYPE.LAST_UPDATE_DATE
, TERRTYPE.LAST_UPDATED_BY
, TERRTYPE.CREATION_DATE
, TERRTYPE.CREATED_BY
, TERRTYPE.LAST_UPDATE_LOGIN
, TERRTYPE.ENABLED_FLAG
, TERRTYPE.NUM_QUALIFIERS
, TERRTYPE.ROLLUP_FLAG
, TERRTYPE.DESCRIPTION
, TERRTYPE.TERRITORY_GROUP_ID
, TERRTYPE.ACCESS_TYPE
, TERRTYPE.RANK
, TERRTYPE.ATTRIBUTE_CATEGORY
, TERRTYPE.ATTRIBUTE1
, TERRTYPE.ATTRIBUTE2
, TERRTYPE.ATTRIBUTE3
, TERRTYPE.ATTRIBUTE4
, TERRTYPE.ATTRIBUTE5
, TERRTYPE.ATTRIBUTE6
, TERRTYPE.ATTRIBUTE7
, TERRTYPE.ATTRIBUTE8
, TERRTYPE.ATTRIBUTE9
, TERRTYPE.ATTRIBUTE10
, TERRTYPE.ATTRIBUTE11
, TERRTYPE.ATTRIBUTE12
, TERRTYPE.ATTRIBUTE13
, TERRTYPE.ATTRIBUTE14
, TERRTYPE.ATTRIBUTE15
, TERRGRP.NAME
, TERRGRP.DESCRIPTION
, TERRGRP.ENABLED_FLAG
, ASLKP2.MEANING
, ASLKP1.MEANING
FROM AS_TERRITORY_TYPES TERRTYPE
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AS_TERRITORY_GROUPS TERRGRP
WHERE TERRTYPE.RANK = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'RANK'
AND TERRTYPE.ACCESS_TYPE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'ACCESS_TYPE'
AND TERRTYPE.TERRITORY_GROUP_ID = TERRGRP.TERRITORY_GROUP_ID(+)