[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_RS_GROUP2_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 2
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SG2_PARENT_GROUP_ID | NUMBER | Yes | Parent sales group id | |
SG2_GROUP_ID | NUMBER | Yes | Sales group id | |
SG2_GROUP_LEVEL1 | NUMBER | Sales group id at relative level 1 | ||
SG2_GROUP_LEVEL2 | NUMBER | Sales group id at relative level 2 | ||
ROLLUP_FLG_LVL2 | 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 SG2_PARENT_GROUP_ID
, SG2_GROUP_ID
, SG2_GROUP_LEVEL1
, SG2_GROUP_LEVEL2
, ROLLUP_FLG_LVL2
, DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUP2_DENORM_V;
APPS.BIL_OBI_RS_GROUP2_DENORM_V is not referenced by any database object
|
|
|