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_TYPE_QUALIFIERS_V

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

View Text

SELECT TYPQUAL.ROWID
, TYPQUAL.TERR_TYPE_QUALIFIER_ID
, TYPQUAL.SEEDED_QUALIFIER_ID
, TYPQUAL.TERRITORY_TYPE_ID
, TYPQUAL.LAST_UPDATE_DATE
, TYPQUAL.LAST_UPDATED_BY
, TYPQUAL.CREATION_DATE
, TYPQUAL.CREATED_BY
, TYPQUAL.LAST_UPDATE_LOGIN
, TYPQUAL.OVERLAP_ALLOWED_FLAG
, SEEDQUAL.QUALIFIER_CODE
, SEEDQUAL.NAME
, SEEDQUAL.TYPE_CODE
, SEEDQUAL.FORMAT_CODE
, SEEDQUAL.ENABLED_FLAG
, SEEDQUAL.DESCRIPTION
, SEEDQUAL.ACCESS_TYPE_CODE
, SEEDQUAL.TYPE
, SEEDQUAL.FORMAT
, SEEDQUAL.ACCESS_TYPE
FROM AS_TERR_TYPE_QUALIFIERS TYPQUAL
, AS_TERR_SEEDED_QUALIFIERS_V SEEDQUAL
WHERE TYPQUAL.SEEDED_QUALIFIER_ID = SEEDQUAL.SEEDED_QUALIFIER_ID

Columns

Name
ROW_ID
TERR_TYPE_QUALIFIER_ID
SEEDED_QUALIFIER_ID
TERRITORY_TYPE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OVERLAP_ALLOWED_FLAG
SEEDQUAL_QUALIFIER_CODE
SEEDQUAL_NAME
SEEDQUAL_TYPE_CODE
SEEDQUAL_FORMAT_CODE
SEEDQUAL_ENABLED_FLAG
SEEDQUAL_DESCRIPTION
SEEDQUAL_ACCESS_TYPE_CODE
SEEDQUAL_TYPE
SEEDQUAL_FORMAT
SEEDQUAL_ACCESS_TYPE