[Home] [Help] [Dependency Information]
Object Name: | MSD_CURR_ONHAND_INVENTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Current Onhand Inventory View
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 |
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;
|
|
|