View: JTF_TERR_DENORM_RULES

Product:	JTF - CRM Foundation
Description:	Denormalized Territory view for performance purposes
Implementation/DBA Data:	APPS.JTF_TERR_DENORM_RULES

View Text

SELECT SOURCE_ID
, QUAL_TYPE_ID
, TERR_ID
, ABSOLUTE_RANK
, RELATIVE_RANK
, NUM_QUAL
, RANK
, LEVEL_FROM_ROOT
, RELATED_TERR_ID
, LEVEL_FROM_PARENT
, TOP_LEVEL_TERR_ID
, NUM_WINNERS
, IMMEDIATE_PARENT_FLAG
, ROOT_FLAG
, LEAF_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
FROM JTF_TERR_DENORM_RULES_ALL

Columns