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


VIEW: APPS.MSD_SR_MFG_FCST_V

Object Details
Object Name: MSD_SR_MFG_FCST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_SR_MFG_FCST_V
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 Manufacturing Forecast. This view would be applied to an Oracle Applications 11i instance from which the Manufacturing Forecast information is to be retrieved.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_DESIGNATOR VARCHAR2 (10) Yes Forecsat Designator
SR_INV_ORG_PK NUMBER

Inv Org Pk
INV_ORG VARCHAR2 (0)
Inv Org
SR_ITEM_PK NUMBER

Item Pk
ITEM VARCHAR2 (0)
Item
SR_CUSTOMER_PK NUMBER

Customer Pk
CUSTOMER VARCHAR2 (0)
Customer
SR_SALES_CHANNEL_PK NUMBER

Sales Channel Pk
SALES_CHANNEL VARCHAR2 (0)
Sales Channel
SR_SHIP_TO_LOC_PK NUMBER

Ship To Loc Pk
SHIP_TO_LOC VARCHAR2 (0)
Ship To Loc
BUCKET_TYPE NUMBER
Yes Bucket Type
FORECAST_DATE DATE
Yes Forecast Date
RATE_END_DATE DATE

Rate End Date
ORIGINAL_QUANTITY NUMBER
Yes Original Quantity
CURRENT_QUANTITY NUMBER
Yes Current 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
SR_DEMAND_CLASS_PK VARCHAR2 (40)
Source Demand Class Primary Key
PRD_LEVEL_ID NUMBER

Product Level Id.
Query Text

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


SELECT FORECAST_DESIGNATOR
,      SR_INV_ORG_PK
,      INV_ORG
,      SR_ITEM_PK
,      ITEM
,      SR_CUSTOMER_PK
,      CUSTOMER
,      SR_SALES_CHANNEL_PK
,      SALES_CHANNEL
,      SR_SHIP_TO_LOC_PK
,      SHIP_TO_LOC
,      BUCKET_TYPE
,      FORECAST_DATE
,      RATE_END_DATE
,      ORIGINAL_QUANTITY
,      CURRENT_QUANTITY
,      SR_USER_DEFINED1_PK
,      USER_DEFINED1
,      SR_USER_DEFINED2_PK
,      USER_DEFINED2
,      SR_DEMAND_CLASS_PK
,      PRD_LEVEL_ID
FROM APPS.MSD_SR_MFG_FCST_V;

Dependencies

[top of page]

APPS.MSD_SR_MFG_FCST_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymMRP_FORECAST_DATES
SynonymMRP_FORECAST_DESIGNATORS
SynonymMSD_APP_INSTANCE_ORGS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS

APPS.MSD_SR_MFG_FCST_V is not referenced by any database object