[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_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.
This is the Source View for Onhand Invetory from SCI Source Instance. This view would be applied to an Oracle Applications SCI instance from which the Onhand Inventory information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Yes | Inv Org Pk | |
INV_ORG | VARCHAR2 | (0) | Inv Org | |
SR_ITEM_PK | NUMBER | Yes | Item Pk | |
ITEM | VARCHAR2 | (0) | Item | |
SR_GEO_LEVEL_PK | NUMBER | Sr Geography Pk | ||
GEOGRAPHY | VARCHAR2 | (0) | Geography | |
SR_SALES_CHANNEL_PK | NUMBER | Sales Channel Pk | ||
SALES_CHANNEL | VARCHAR2 | (0) | Sales Channel | |
SR_SALES_REP_PK | NUMBER | Sales Rep Pk | ||
SALES_REP | VARCHAR2 | (0) | Sales Rep | |
SR_DEMAND_CLASS_PK | NUMBER | Sr Demand Class Pk | ||
DEMAND_CLASS | VARCHAR2 | (0) | Demand Class | |
ACTUAL_DATE | DATE | Yes | End Date | |
QUANTITY | NUMBER | Quantity | ||
SR_USER_DEFINED1_PK | NUMBER | User Defined1 Pk | ||
USER_DEFINED1 | VARCHAR2 | (0) | User Defined1 | |
SR_USER_DEFINED2_PK | NUMBER | User Defined2 Pk | ||
USER_DEFINED2 | VARCHAR2 | (0) | User Defined2 |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INV_ORG_PK
, INV_ORG
, SR_ITEM_PK
, ITEM
, SR_GEO_LEVEL_PK
, GEOGRAPHY
, SR_SALES_CHANNEL_PK
, SALES_CHANNEL
, SR_SALES_REP_PK
, SALES_REP
, SR_DEMAND_CLASS_PK
, DEMAND_CLASS
, ACTUAL_DATE
, QUANTITY
, SR_USER_DEFINED1_PK
, USER_DEFINED1
, SR_USER_DEFINED2_PK
, USER_DEFINED2
FROM APPS.MSD_SR_ONHAND_INVENTORY_V;
APPS.MSD_SR_ONHAND_INVENTORY_V is not referenced by any database object
|
|
|