[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_RS_GROUP0_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 zero
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SG0_PARENT_GROUP_ID | NUMBER | Yes | Parent sales group id | |
SG0_GROUP_ID | NUMBER | Yes | Sales group id | |
ROLLUP_FLG_LVL0 | VARCHAR2 | (1) | Flag to show rolled-up and non rolled up groups | |
DENORM_LEVEL | NUMBER | Relative level of sales group |
Cut, paste (and edit) the following text to query this object:
SELECT SG0_PARENT_GROUP_ID
, SG0_GROUP_ID
, ROLLUP_FLG_LVL0
, DENORM_LEVEL
FROM APPS.BIL_OBI_RS_GROUP0_DENORM_V;
APPS.BIL_OBI_RS_GROUP0_DENORM_V is not referenced by any database object
|
|
|