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

VIEW: APPS.MRP_FORECAST_DATES_V

Object Details
Object Name: MRP_FORECAST_DATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_FORECAST_DATES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
TRANSACTION_ID NUMBER
Yes Transaction identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
FORECAST_DESIGNATOR VARCHAR2 (10) Yes Item forecast identifier
FORECAST_DATE DATE
Yes Forecast date
ORIGINAL_FORECAST_QUANTITY NUMBER
Yes Original forecast quantity
CURRENT_FORECAST_QUANTITY NUMBER
Yes Current forecast quantity
CONFIDENCE_PERCENTAGE NUMBER
Yes Forecast confidence percentage
BUCKET_TYPE NUMBER
Yes Bucket type
RATE_END_DATE DATE

Rate end date
ORIGINATION_TYPE NUMBER
Yes Origination type
ORIGINATION_TYPE_DESC VARCHAR2 (80) Yes Origination type description
CUSTOMER_ID NUMBER

Forecast customer identifier
SHIP_ID NUMBER

Forecast ship code identifier
BILL_ID NUMBER

Forecast billing address identifier
COMMENTS VARCHAR2 (240)
Forecast origination remarks
SOURCE_ORGANIZATION_ID NUMBER

Organization identifier from which this row was loaded
SOURCE_ORGANIZATION_CODE VARCHAR2 (3)
Organization code from which this row was loaded
SOURCE_FORECAST_DESIGNATOR VARCHAR2 (10)
Forecast designator from which this row was loaded
SOURCE_CODE VARCHAR2 (10)
Source code name of the program which loaded corresponding row in MRP_FORECAST_INTERFACE table
SOURCE_LINE_ID NUMBER

Source code line number of the host program which loaded the corresponding row in MRP_FORECAST_INTERFACE table
END_ITEM_ID NUMBER

End item for entries exploded from another item
END_PLANNING_BOM_PERCENT NUMBER

End planning percent for entries exploded from another item
FORECAST_RULE_ID NUMBER

Forecast rule identifier
DEMAND_USAGE_START_DATE DATE

Demand history compilation date
FORECAST_TREND NUMBER

Forecast trend
FOCUS_TYPE NUMBER

Focus type
FORECAST_MAD NUMBER

Forecasting average
DEMAND_CLASS VARCHAR2 (30)
Demand class identifier
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
DDF_CONTEXT VARCHAR2 (30)
Descriptive flexfield context column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PROJECT_ID NUMBER (15)
Project identifier
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_ID NUMBER (15)
Task identifier
TASK_NUMBER VARCHAR2 (4000)
Task number
LINE_ID NUMBER

Line identifier
LINE_CODE VARCHAR2 (10)
Line code
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item Name
Query Text

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


SELECT ROW_ID
,      TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      FORECAST_DESIGNATOR
,      FORECAST_DATE
,      ORIGINAL_FORECAST_QUANTITY
,      CURRENT_FORECAST_QUANTITY
,      CONFIDENCE_PERCENTAGE
,      BUCKET_TYPE
,      RATE_END_DATE
,      ORIGINATION_TYPE
,      ORIGINATION_TYPE_DESC
,      CUSTOMER_ID
,      SHIP_ID
,      BILL_ID
,      COMMENTS
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_FORECAST_DESIGNATOR
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      END_ITEM_ID
,      END_PLANNING_BOM_PERCENT
,      FORECAST_RULE_ID
,      DEMAND_USAGE_START_DATE
,      FORECAST_TREND
,      FOCUS_TYPE
,      FORECAST_MAD
,      DEMAND_CLASS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DDF_CONTEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      LINE_ID
,      LINE_CODE
,      CONCATENATED_SEGMENTS
FROM APPS.MRP_FORECAST_DATES_V;

Dependencies

[top of page]

APPS.MRP_FORECAST_DATES_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_FORECAST_DATES
PL/SQL PackageMRP_GET_PROJECT - show dependent code
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_PARAMETERS
SynonymWIP_LINES

APPS.MRP_FORECAST_DATES_V is not referenced by any database object