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

VIEW: APPS.BIL_OBI_RS_GROUP1_DENORM_V

Object Details
Object Name: BIL_OBI_RS_GROUP1_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 1


[View Source]

Columns
Name Datatype Length Mandatory Comments
SG1_PARENT_GROUP_ID NUMBER
Yes Parent sales group id
SG1_GROUP_ID NUMBER
Yes Sales group id
SG1_GROUP_LEVEL1 NUMBER

Sales group id at relative level 1
ROLLUP_FLG_LVL1 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 SG1_PARENT_GROUP_ID
,      SG1_GROUP_ID
,      SG1_GROUP_LEVEL1
,      ROLLUP_FLG_LVL1
,      DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUP1_DENORM_V;

Dependencies

[top of page]

APPS.BIL_OBI_RS_GROUP1_DENORM_V references the following:

SchemaAPPS
SynonymBIL_OBI_RS_GROUPS_DENORM

APPS.BIL_OBI_RS_GROUP1_DENORM_V is not referenced by any database object