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

VIEW: APPS.BIL_OBI_RS_GROUP3_DENORM_V

Object Details
Object Name: BIL_OBI_RS_GROUP3_DENORM_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 denorm view for relative level equal to and less than 3


[View Source]

Columns
Name Datatype Length Mandatory Comments
SG3_PARENT_GROUP_ID NUMBER
Yes parent sales group id
SG3_GROUP_ID NUMBER
Yes Sales group id
SG3_GROUP_LEVEL1 NUMBER

Sales group id at relative level 1
SG3_GROUP_LEVEL2 NUMBER

Sales group id at relative level 2
SG3_GROUP_LEVEL3 NUMBER

Sales group id at relative level 3
ROLLUP_FLG_LVL3 VARCHAR2 (1)
Flag for rolled-up and non rolled up sales groups
DENORM_LEVEL NUMBER

Relative level of sales group
Query Text

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


SELECT SG3_PARENT_GROUP_ID
,      SG3_GROUP_ID
,      SG3_GROUP_LEVEL1
,      SG3_GROUP_LEVEL2
,      SG3_GROUP_LEVEL3
,      ROLLUP_FLG_LVL3
,      DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUP3_DENORM_V;

Dependencies

[top of page]

APPS.BIL_OBI_RS_GROUP3_DENORM_V references the following:

SchemaAPPS
SynonymBIL_OBI_RS_GROUPS_DENORM

APPS.BIL_OBI_RS_GROUP3_DENORM_V is not referenced by any database object