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

VIEW: APPS.GMP_SR_MFG_FCST_V

Object Details
Object Name: GMP_SR_MFG_FCST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_SR_MFG_FCST_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Manufacturing Forecast for Demand Planner


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_DESIGNATOR VARCHAR2 (0)
Forecast Name
SR_INV_ORG_PK NUMBER

Inventory Organziation Id
INV_ORG VARCHAR2 (0)
Inventory Organization Name
SR_ITEM_PK NUMBER

Item Id
ITEM VARCHAR2 (0)
Item Nnumber
SR_CUSTOMER_PK NUMBER

Customer Id
CUSTOMER VARCHAR2 (0)
Customer Name
SR_SALES_CHANNEL_PK NUMBER

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

Ship To Location Id
SHIP_TO_LOC VARCHAR2 (0)
Ship To Location
BUCKET_TYPE NUMBER

Time Bucket Type
FORECAST_DATE DATE

Date of the Forecasted qty
RATE_END_DATE DATE

End date for rate based forecast
ORIGINAL_QUANTITY NUMBER

Original forecast quantity
CURRENT_QUANTITY NUMBER

Current quantity
SR_USER_DEFINED1_PK VARCHAR2 (0)
User defined
USER_DEFINED1 VARCHAR2 (0)
User defined
SR_USER_DEFINED2_PK VARCHAR2 (0)
User defined
USER_DEFINED2 VARCHAR2 (0)
User defined
PRD_LEVEL_ID NUMBER

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
,      PRD_LEVEL_ID
FROM APPS.GMP_SR_MFG_FCST_V;

Dependencies

[top of page]

APPS.GMP_SR_MFG_FCST_V references the following:

SchemaSYS
TableDUAL

APPS.GMP_SR_MFG_FCST_V is not referenced by any database object