eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AS_TERR_GRP_TYPE_V

Product:	AS - Sales Foundation
Description:	Territory information summary view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT GR.TERRITORY_GROUP_ID
, GR.NAME GROUP_NAME
, GR.ENABLED_FLAG TERR_GRP_ENABLED_FLAG
, TY.TERRITORY_TYPE_ID
, TY.NAME TERR_TYPE_NAME
, TY.ENABLED_FLAG TERR_TYPE_ENABLED_FLAG
, TY.RANK
, TY.ROLLUP_FLAG
, TE.TERRITORY_ID
, TE.NAME TERR_NAME
, TE.ENABLED_FLAG TERR_ENABLED_FLAG
, TE.SALESFORCE_ID
, TE.EMP_LAST_NAME
, TE.EMP_FIRST_NAME
, TE.NUM_QUALIFIERS
, TE.ACCESS_TYPE_CODE
, TE.START_DATE_ACTIVE
, TE.END_DATE_ACTIVE
, TE.TEAM_LEADER_FLAG
, TE.ACTIVATED_FLAG
, TE.DEACTIVATED_FLAG
, TE.PARTNER_PERSON_ID
, TE.PARTNER_ADDRESS_ID
, TE.PARTNER_CUSTOMER_ID
, TE.PARTNER
FROM AS_TERRITORY_GROUPS GR
, AS_TERRITORY_TYPES TY
, AS_TERRITORIES_V TE
WHERE GR.TERRITORY_GROUP_ID = TY.TERRITORY_GROUP_ID
AND TY.TERRITORY_TYPE_ID = TE.TERRITORY_TYPE_ID

Columns

Name
TERRITORY_GROUP_ID
GROUP_NAME
TERR_GRP_ENABLED_FLAG
TERRITORY_TYPE_ID
TERR_TYPE_NAME
TERR_TYPE_ENABLED_FLAG
RANK
ROLLUP_FLAG
TERRITORY_ID
TERR_NAME
TERR_ENABLED_FLAG
SALESFORCE_ID
EMP_LAST_NAME
EMP_FIRST_NAME
NUM_QUALIFIERS
ACCESS_TYPE_CODE
START_DATE_ACTIVE
END_DATE_ACTIVE
TEAM_LEADER_FLAG
ACTIVATED_FLAG
DEACTIVATED_FLAG
PARTNER_PERSON_ID
PARTNER_ADDRESS_ID
PARTNER_CUSTOMER_ID
PARTNER