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

VIEW: APPS.MSD_SR_PRD_CAT_LB_V

Object Details
Object Name: MSD_SR_PRD_CAT_LB_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.


This is the Source View that associates the Product level to Product Category level in the Product Dimension for Liability Analysis. This view would be applied to an Oracle Applications 11i instance from which the Product to Product Category level association information is to be retrieved.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan Id
LEVEL_ID NUMBER

Level id
LEVEL_VALUE VARCHAR2 (250)
Level Value
LEVEL_VALUE_DESC VARCHAR2 (240)
Level Value Description
LEVEL_VALUE_PK NUMBER
Yes Level Value Primary Key
PARENT_LEVEL_ID NUMBER

Parent Level Id
PARENT_VALUE VARCHAR2 (4000)
Parent Value
PARENT_VALUE_DESC VARCHAR2 (4000)
Parent Value Description
PARENT_VALUE_PK VARCHAR2 (4000)
Parent Value Primary key
Query Text

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_PRD_CAT_LB_V;

Dependencies

[top of page]

APPS.MSD_SR_PRD_CAT_LB_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_ASL_AUTH_DETAILS
SynonymMSC_ITEM_SUPPLIERS
SynonymMSC_PLANS
SynonymMSC_SYSTEM_ITEMS
PL/SQL PackageMSD_COMMON_UTILITIES_LB - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.MSD_SR_PRD_CAT_LB_V is not referenced by any database object