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

VIEW: APPS.BIL_OBI_RS_GROUPB_DENORM_V

Object Details
Object Name: BIL_OBI_RS_GROUPB_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 5


[View Source]

Columns
Name Datatype Length Mandatory Comments
SGB_PARENT_GROUP_ID NUMBER
Yes Parent sales group Id
SGB_GROUP_ID NUMBER
Yes Sales group id
SGB_GROUP_LEVEL1 NUMBER

Sales group id at relative level 1
SGB_GROUP_LEVEL2 NUMBER

Sales group id at relative level 2
SGB_GROUP_LEVEL3 NUMBER

Sales group id at relative level 3
SGB_GROUP_LEVEL4 NUMBER

Sales group id at relative level 4
ROLLUP_FLG_LVLB 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 SGB_PARENT_GROUP_ID
,      SGB_GROUP_ID
,      SGB_GROUP_LEVEL1
,      SGB_GROUP_LEVEL2
,      SGB_GROUP_LEVEL3
,      SGB_GROUP_LEVEL4
,      ROLLUP_FLG_LVLB
,      DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUPB_DENORM_V;

Dependencies

[top of page]

APPS.BIL_OBI_RS_GROUPB_DENORM_V references the following:

SchemaAPPS
SynonymBIL_OBI_RS_GROUPS_DENORM

APPS.BIL_OBI_RS_GROUPB_DENORM_V is not referenced by any database object