[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_RS_GROUP3_DENORM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
APPS.BIL_OBI_RS_GROUP3_DENORM_V is not referenced by any database object
|
|
|