[Home] [Help]
View: AS_TERR_ROLLUPS_IMMEDIATE_V
Product: | AS - Sales Foundation |
Description: | Territory rollups view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TERRVAL.ROWID
, TERRVAL.TERRITORY_ID
, TERRVAL.ROLLUP_TERRITORY_ID
FROM AS_TERRITORY_VALUES TERRVAL
, AS_TERR_SEED_QUALIFIERS_VL SEEDQUAL
WHERE SEEDQUAL.QUALIFIER_CODE = 'TERRITORY_NAME'
AND TERRVAL.SEEDED_QUALIFIER_ID = SEEDQUAL.SEEDED_QUALIFIER_ID
Columns
Name |
ROW_ID |
TERRITORY_ID |
ROLLUP_TERRITORY_ID |