DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPR_SR_SG_HIER_V

Object Details
Object Name: QPR_SR_SG_HIER_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Sales group hierarchy source view


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEVEL1_VALUE NUMBER

Sales representative
LEVEL1_DESC VARCHAR2 (4000)
Sales representative
LEVEL1_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL1_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL1_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL1_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL1_ATTRIBUTE5 VARCHAR2 (0)
Not used
LEVEL2_VALUE NUMBER

Sales group 1
LEVEL2_DESC VARCHAR2 (4000)
Sales group 1
LEVEL2_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL2_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL2_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL2_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL2_ATTRIBUTE5 VARCHAR2 (0)
Not used
LEVEL3_VALUE NUMBER

Sales group 2
LEVEL3_DESC VARCHAR2 (4000)
Sales group 2
LEVEL3_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL3_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL3_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL3_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL3_ATTRIBUTE5 VARCHAR2 (0)
Not used
LEVEL4_VALUE NUMBER

Sales group 3
LEVEL4_DESC VARCHAR2 (4000)
Sales group 3
LEVEL4_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL4_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL4_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL4_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL4_ATTRIBUTE5 VARCHAR2 (0)
Not used
LEVEL5_VALUE NUMBER

Sales group 4
LEVEL5_DESC VARCHAR2 (4000)
Sales group 4
LEVEL5_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL5_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL5_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL5_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL5_ATTRIBUTE5 VARCHAR2 (0)
Not used
LEVEL6_VALUE NUMBER

All sales groups
LEVEL6_DESC VARCHAR2 (4000)
All sales group
LEVEL6_ATTRIBUTE1 VARCHAR2 (0)
Not used
LEVEL6_ATTRIBUTE2 VARCHAR2 (0)
Not used
LEVEL6_ATTRIBUTE3 VARCHAR2 (0)
Not used
LEVEL6_ATTRIBUTE4 VARCHAR2 (0)
Not used
LEVEL6_ATTRIBUTE5 VARCHAR2 (0)
Not used
LAST_UPDATE_DATE DATE

Update date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEVEL1_VALUE
,      LEVEL1_DESC
,      LEVEL1_ATTRIBUTE1
,      LEVEL1_ATTRIBUTE2
,      LEVEL1_ATTRIBUTE3
,      LEVEL1_ATTRIBUTE4
,      LEVEL1_ATTRIBUTE5
,      LEVEL2_VALUE
,      LEVEL2_DESC
,      LEVEL2_ATTRIBUTE1
,      LEVEL2_ATTRIBUTE2
,      LEVEL2_ATTRIBUTE3
,      LEVEL2_ATTRIBUTE4
,      LEVEL2_ATTRIBUTE5
,      LEVEL3_VALUE
,      LEVEL3_DESC
,      LEVEL3_ATTRIBUTE1
,      LEVEL3_ATTRIBUTE2
,      LEVEL3_ATTRIBUTE3
,      LEVEL3_ATTRIBUTE4
,      LEVEL3_ATTRIBUTE5
,      LEVEL4_VALUE
,      LEVEL4_DESC
,      LEVEL4_ATTRIBUTE1
,      LEVEL4_ATTRIBUTE2
,      LEVEL4_ATTRIBUTE3
,      LEVEL4_ATTRIBUTE4
,      LEVEL4_ATTRIBUTE5
,      LEVEL5_VALUE
,      LEVEL5_DESC
,      LEVEL5_ATTRIBUTE1
,      LEVEL5_ATTRIBUTE2
,      LEVEL5_ATTRIBUTE3
,      LEVEL5_ATTRIBUTE4
,      LEVEL5_ATTRIBUTE5
,      LEVEL6_VALUE
,      LEVEL6_DESC
,      LEVEL6_ATTRIBUTE1
,      LEVEL6_ATTRIBUTE2
,      LEVEL6_ATTRIBUTE3
,      LEVEL6_ATTRIBUTE4
,      LEVEL6_ATTRIBUTE5
,      LAST_UPDATE_DATE
FROM APPS.QPR_SR_SG_HIER_V;

Dependencies

[top of page]

APPS.QPR_SR_SG_HIER_V references the following:

SchemaAPPS
SynonymJTF_RS_GROUPS_DENORM
ViewJTF_RS_GROUPS_VL
SynonymJTF_RS_GROUP_MEMBERS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymJTF_RS_SALESREPS
PL/SQL PackageQPR_SR_UTIL - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.QPR_SR_SG_HIER_V is not referenced by any database object