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

VIEW: APPS.MSD_CURR_ONHAND_INVENTORY_V

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


Current Onhand Inventory View


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID VARCHAR2 (40) Yes Plan Id
ORG_LEVEL_ID NUMBER
Yes Org Level Id
ORG_SR_LEVEL_PK VARCHAR2 (240) Yes Org Level Primary Key
PRD_LEVEL_ID NUMBER
Yes Product Level Id
PRD_SR_LEVEL_PK VARCHAR2 (240) Yes Product Level Value Primary Key
GEO_LEVEL_ID NUMBER

Geo Level Id
GEO_SR_LEVEL_PK NUMBER

Geo Level Value Primary Key
DCS_LEVEL_ID NUMBER

Geo Level Id
DCS_SR_LEVEL_PK NUMBER

Geo Level Value Primary Key
TIME_LEVEL_ID NUMBER

Time Level Id
END_DATE DATE

Completion Date
QUANTITY NUMBER

Quantity
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SR_INSTANCE_ID
,      ORG_LEVEL_ID
,      ORG_SR_LEVEL_PK
,      PRD_LEVEL_ID
,      PRD_SR_LEVEL_PK
,      GEO_LEVEL_ID
,      GEO_SR_LEVEL_PK
,      DCS_LEVEL_ID
,      DCS_SR_LEVEL_PK
,      TIME_LEVEL_ID
,      END_DATE
,      QUANTITY
FROM APPS.MSD_CURR_ONHAND_INVENTORY_V;

Dependencies

[top of page]

APPS.MSD_CURR_ONHAND_INVENTORY_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_SUPPLIES
SynonymMSC_SYSTEM_ITEMS
PL/SQL PackageMSD_COMMON_UTILITIES - show dependent code
SynonymMSD_LEVEL_VALUES
SchemaPUBLIC
SynonymDUAL
APPS.MSD_CURR_ONHAND_INVENTORY_V is referenced by following:

SchemaAPPS
Package BodyMSD_CS_COLLECTION - show dependent code