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_SEEDED_QUALIFIERS_V

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

View Text

SELECT SEEDQUAL.ROWID
, SEEDQUAL.SEEDED_QUALIFIER_ID
, SEEDQUAL.LAST_UPDATE_DATE
, SEEDQUAL.LAST_UPDATED_BY
, SEEDQUAL.CREATION_DATE
, SEEDQUAL.CREATED_BY
, SEEDQUAL.LAST_UPDATE_LOGIN
, SEEDQUAL.QUALIFIER_CODE
, SEEDQUAL.NAME
, SEEDQUAL.TYPE
, SEEDQUAL.FORMAT
, SEEDQUAL.ENABLED_FLAG
, SEEDQUAL.DESCRIPTION
, SEEDQUAL.ACCESS_TYPE
, ASLKP1.MEANING
, ASLKP2.MEANING
, ASLKP3.MEANING
FROM AS_TERR_SEED_QUALIFIERS_VL SEEDQUAL
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AS_LOOKUPS ASLKP3
WHERE ASLKP1.LOOKUP_TYPE = 'QUALIFIER_TYPE'
AND ASLKP1.LOOKUP_CODE = SEEDQUAL.TYPE
AND ASLKP2.LOOKUP_TYPE = 'QUALIFIER_FORMAT'
AND ASLKP2.LOOKUP_CODE = SEEDQUAL.FORMAT
AND ASLKP3.LOOKUP_TYPE(+) = 'ACCESS_TYPE'
AND ASLKP3.LOOKUP_CODE(+) = SEEDQUAL.ACCESS_TYPE

Columns

Name
ROW_ID
SEEDED_QUALIFIER_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
QUALIFIER_CODE
NAME
TYPE_CODE
FORMAT_CODE
ENABLED_FLAG
DESCRIPTION
ACCESS_TYPE_CODE
TYPE
FORMAT
ACCESS_TYPE