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

VIEW: APPS.BIL_OBI_RS_GROUP4_DENORM_V

Object Details
Object Name: BIL_OBI_RS_GROUP4_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 4


[View Source]

Columns
Name Datatype Length Mandatory Comments
SG4_PARENT_GROUP_ID NUMBER
Yes Parent sales group id
SG4_GROUP_ID NUMBER
Yes Sales group id
SG4_GROUP_LEVEL1 NUMBER

Sales group id at relative level 1
SG4_GROUP_LEVEL2 NUMBER

Sales group id at relative level 2
SG4_GROUP_LEVEL3 NUMBER

Sales group id at relative level 3
SG4_GROUP_LEVEL4 NUMBER

Sales group id at relative level 4
ROLLUP_FLG_LVL4 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 SG4_PARENT_GROUP_ID
,      SG4_GROUP_ID
,      SG4_GROUP_LEVEL1
,      SG4_GROUP_LEVEL2
,      SG4_GROUP_LEVEL3
,      SG4_GROUP_LEVEL4
,      ROLLUP_FLG_LVL4
,      DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUP4_DENORM_V;

Dependencies

[top of page]

APPS.BIL_OBI_RS_GROUP4_DENORM_V references the following:

SchemaAPPS
SynonymBIL_OBI_RS_GROUPS_DENORM

APPS.BIL_OBI_RS_GROUP4_DENORM_V is not referenced by any database object