[Home] [Help] [Dependency Information]
Object Name: | ICX_MRP_FORECAST_DATES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_MRP_FORECAST_DATES_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
The ICX_MRP_FORECAST_DATES_V view is used by the Self-Service Web
Applications and displays forecast entries. This view is based on the
MRP_FORECAST_DATES table.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
FORECAST_DESIGNATOR | VARCHAR2 | (10) | Yes | Forecast designator |
BUCKET_TYPE | NUMBER | Yes | Bucket type | |
BUCKET_TYPE_DESC | VARCHAR2 | (80) | Yes | Bucket type description |
FORECAST_DATE | DATE | Yes | Forecast date | |
RATE_END_DATE | DATE | Rate end date | ||
CURRENT_FORECAST_QUANTITY | NUMBER | Yes | Current forecast quantity | |
ORIGINAL_FORECAST_QUANTITY | NUMBER | Yes | Original forecast quantity | |
CONFIDENCE_PERCENTAGE | NUMBER | Yes | Forecast confidence percentage | |
ORIGINATION_TYPE | NUMBER | Yes | Origination type | |
ORIGINATION_TYPE_DESC | VARCHAR2 | (80) | Yes | Origination type description |
CUSTOMER_ID | NUMBER | 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 | Source organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SOURCE_FORECAST_DESIGNATOR | VARCHAR2 | (10) | Forecast designator from which this row is loaded | |
SOURCE_CODE | VARCHAR2 | (10) | Source code name of the program which loaded the 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_ITEM_SEGMENT | VARCHAR2 | (40) | End item number | |
END_PLANNING_BOM_PERCENT | NUMBER | End planning percent for entries exploded from another item | ||
DEMAND_CLASS | VARCHAR2 | (30) | Demand class | |
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 | |
ITEM_SEGMENTS | VARCHAR2 | (40) | ITEM SEGMENTS |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TRANSACTION_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, FORECAST_DESIGNATOR
, BUCKET_TYPE
, BUCKET_TYPE_DESC
, FORECAST_DATE
, RATE_END_DATE
, CURRENT_FORECAST_QUANTITY
, ORIGINAL_FORECAST_QUANTITY
, CONFIDENCE_PERCENTAGE
, ORIGINATION_TYPE
, ORIGINATION_TYPE_DESC
, CUSTOMER_ID
, SHIP_ID
, BILL_ID
, COMMENTS
, SOURCE_ORGANIZATION_ID
, ORGANIZATION_CODE
, SOURCE_FORECAST_DESIGNATOR
, SOURCE_CODE
, SOURCE_LINE_ID
, END_ITEM_ID
, END_ITEM_SEGMENT
, END_PLANNING_BOM_PERCENT
, DEMAND_CLASS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, ITEM_SEGMENTS
FROM APPS.ICX_MRP_FORECAST_DATES_V;
APPS.ICX_MRP_FORECAST_DATES_V is not referenced by any database object
|
|
|