[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_CAT_ALL_LB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view brings the relationship between Category and all Products. This view is used in liability Analysis
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ASCP Plan Id or -1 in case of collaborative Plan Id | |
LEVEL_ID | NUMBER | Level Id of Product Category | ||
LEVEL_VALUE | VARCHAR2 | (4000) | Level Value | |
LEVEL_VALUE_DESC | VARCHAR2 | (4000) | Level Value Desc | |
LEVEL_VALUE_PK | VARCHAR2 | (4000) | Level Values Pk | |
PARENT_LEVEL_ID | NUMBER | Parent Level Id | ||
PARENT_VALUE | VARCHAR2 | (4000) | Parent Value | |
PARENT_VALUE_DESC | VARCHAR2 | (4000) | Parent Value desc | |
PARENT_VALUE_PK | NUMBER | Parent Value Pk |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, LEVEL_ID
, LEVEL_VALUE
, LEVEL_VALUE_DESC
, LEVEL_VALUE_PK
, PARENT_LEVEL_ID
, PARENT_VALUE
, PARENT_VALUE_DESC
, PARENT_VALUE_PK
FROM APPS.MSD_SR_CAT_ALL_LB_V;
APPS.MSD_SR_CAT_ALL_LB_V is not referenced by any database object
|
|
|