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


VIEW: APPS.MSD_SR_ONHAND_INVENTORY_V

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


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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.MSD_SR_ONHAND_INVENTORY_V references the following:

SchemaAPPS
ViewFII_TIME_RPT_STRUCT_V
SynonymMSD_APP_INSTANCE_ORGS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS
TableOPI_INV_VAL_SUM_MV

APPS.MSD_SR_ONHAND_INVENTORY_V is not referenced by any database object