eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_FORECAST_DATES_COST_V

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_FORECAST_DATES_COST_V

View Text

SELECT FRCT.TRANSACTION_ID
, FRCT.LAST_UPDATE_DATE
, FRCT.LAST_UPDATED_BY
, FRCT.CREATION_DATE
, FRCT.CREATED_BY
, FRCT.LAST_UPDATE_LOGIN
, FRCT.INVENTORY_ITEM_ID
, FRCT.ORGANIZATION_ID
, FRCT.FORECAST_DESIGNATOR
, FRCT.FORECAST_DATE
, FRCT.ORIGINAL_FORECAST_QUANTITY
, FRCT.CURRENT_FORECAST_QUANTITY
, FRCT.CONFIDENCE_PERCENTAGE
, FRCT.BUCKET_TYPE
, FRCT.RATE_END_DATE
, FRCT.ORIGINATION_TYPE
, FRCT.CUSTOMER_ID
, FRCT.SHIP_ID
, FRCT.BILL_ID
, FRCT.COMMENTS
, FRCT.SOURCE_ORGANIZATION_ID
, FRCT.SOURCE_FORECAST_DESIGNATOR
, FRCT.SOURCE_CODE
, FRCT.SOURCE_LINE_ID
, FRCT.END_ITEM_ID
, FRCT.END_PLANNING_BOM_PERCENT
, FRCT.FORECAST_RULE_ID
, FRCT.DEMAND_USAGE_START_DATE
, FRCT.FORECAST_TREND
, FRCT.FOCUS_TYPE
, FRCT.FORECAST_MAD
, FRCT.DEMAND_CLASS
, FRCT.REQUEST_ID
, FRCT.PROGRAM_APPLICATION_ID
, FRCT.PROGRAM_ID
, FRCT.PROGRAM_UPDATE_DATE
, FRCT.DDF_CONTEXT
, FRCT.ATTRIBUTE_CATEGORY
, FRCT.ATTRIBUTE1
, FRCT.ATTRIBUTE2
, FRCT.ATTRIBUTE3
, FRCT.ATTRIBUTE4
, FRCT.ATTRIBUTE5
, FRCT.ATTRIBUTE6
, FRCT.ATTRIBUTE7
, FRCT.ATTRIBUTE8
, FRCT.ATTRIBUTE9
, FRCT.ATTRIBUTE10
, FRCT.ATTRIBUTE11
, FRCT.ATTRIBUTE12
, FRCT.ATTRIBUTE13
, FRCT.ATTRIBUTE14
, FRCT.ATTRIBUTE15
, FRCT.OLD_TRANSACTION_ID
, FRCT.TO_UPDATE
, FRCT.PROJECT_ID
, FRCT.TASK_ID
, CCICV.ITEM_COST
FROM MRP_FORECAST_DATES FRCT
, CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE FRCT.PROJECT_ID IS NULL
AND CCICV.ORGANIZATION_ID = FRCT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = FRCT.INVENTORY_ITEM_ID
AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1)) UNION ALL SELECT FRCT.TRANSACTION_ID
, FRCT.LAST_UPDATE_DATE
, FRCT.LAST_UPDATED_BY
, FRCT.CREATION_DATE
, FRCT.CREATED_BY
, FRCT.LAST_UPDATE_LOGIN
, FRCT.INVENTORY_ITEM_ID
, FRCT.ORGANIZATION_ID
, FRCT.FORECAST_DESIGNATOR
, FRCT.FORECAST_DATE
, FRCT.ORIGINAL_FORECAST_QUANTITY
, FRCT.CURRENT_FORECAST_QUANTITY
, FRCT.CONFIDENCE_PERCENTAGE
, FRCT.BUCKET_TYPE
, FRCT.RATE_END_DATE
, FRCT.ORIGINATION_TYPE
, FRCT.CUSTOMER_ID
, FRCT.SHIP_ID
, FRCT.BILL_ID
, FRCT.COMMENTS
, FRCT.SOURCE_ORGANIZATION_ID
, FRCT.SOURCE_FORECAST_DESIGNATOR
, FRCT.SOURCE_CODE
, FRCT.SOURCE_LINE_ID
, FRCT.END_ITEM_ID
, FRCT.END_PLANNING_BOM_PERCENT
, FRCT.FORECAST_RULE_ID
, FRCT.DEMAND_USAGE_START_DATE
, FRCT.FORECAST_TREND
, FRCT.FOCUS_TYPE
, FRCT.FORECAST_MAD
, FRCT.DEMAND_CLASS
, FRCT.REQUEST_ID
, FRCT.PROGRAM_APPLICATION_ID
, FRCT.PROGRAM_ID
, FRCT.PROGRAM_UPDATE_DATE
, FRCT.DDF_CONTEXT
, FRCT.ATTRIBUTE_CATEGORY
, FRCT.ATTRIBUTE1
, FRCT.ATTRIBUTE2
, FRCT.ATTRIBUTE3
, FRCT.ATTRIBUTE4
, FRCT.ATTRIBUTE5
, FRCT.ATTRIBUTE6
, FRCT.ATTRIBUTE7
, FRCT.ATTRIBUTE8
, FRCT.ATTRIBUTE9
, FRCT.ATTRIBUTE10
, FRCT.ATTRIBUTE11
, FRCT.ATTRIBUTE12
, FRCT.ATTRIBUTE13
, FRCT.ATTRIBUTE14
, FRCT.ATTRIBUTE15
, FRCT.OLD_TRANSACTION_ID
, FRCT.TO_UPDATE
, FRCT.PROJECT_ID
, FRCT.TASK_ID
, 0
FROM MRP_FORECAST_DATES FRCT
WHERE FRCT.PROJECT_ID IS NULL
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
, MTL_PARAMETERS MP
WHERE CCICV.ORGANIZATION_ID = FRCT.ORGANIZATION_ID AND CCICV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = FRCT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = DECODE( MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1))) UNION ALL SELECT FRCT.TRANSACTION_ID
, FRCT.LAST_UPDATE_DATE
, FRCT.LAST_UPDATED_BY
, FRCT.CREATION_DATE
, FRCT.CREATED_BY
, FRCT.LAST_UPDATE_LOGIN
, FRCT.INVENTORY_ITEM_ID
, FRCT.ORGANIZATION_ID
, FRCT.FORECAST_DESIGNATOR
, FRCT.FORECAST_DATE
, FRCT.ORIGINAL_FORECAST_QUANTITY
, FRCT.CURRENT_FORECAST_QUANTITY
, FRCT.CONFIDENCE_PERCENTAGE
, FRCT.BUCKET_TYPE
, FRCT.RATE_END_DATE
, FRCT.ORIGINATION_TYPE
, FRCT.CUSTOMER_ID
, FRCT.SHIP_ID
, FRCT.BILL_ID
, FRCT.COMMENTS
, FRCT.SOURCE_ORGANIZATION_ID
, FRCT.SOURCE_FORECAST_DESIGNATOR
, FRCT.SOURCE_CODE
, FRCT.SOURCE_LINE_ID
, FRCT.END_ITEM_ID
, FRCT.END_PLANNING_BOM_PERCENT
, FRCT.FORECAST_RULE_ID
, FRCT.DEMAND_USAGE_START_DATE
, FRCT.FORECAST_TREND
, FRCT.FOCUS_TYPE
, FRCT.FORECAST_MAD
, FRCT.DEMAND_CLASS
, FRCT.REQUEST_ID
, FRCT.PROGRAM_APPLICATION_ID
, FRCT.PROGRAM_ID
, FRCT.PROGRAM_UPDATE_DATE
, FRCT.DDF_CONTEXT
, FRCT.ATTRIBUTE_CATEGORY
, FRCT.ATTRIBUTE1
, FRCT.ATTRIBUTE2
, FRCT.ATTRIBUTE3
, FRCT.ATTRIBUTE4
, FRCT.ATTRIBUTE5
, FRCT.ATTRIBUTE6
, FRCT.ATTRIBUTE7
, FRCT.ATTRIBUTE8
, FRCT.ATTRIBUTE9
, FRCT.ATTRIBUTE10
, FRCT.ATTRIBUTE11
, FRCT.ATTRIBUTE12
, FRCT.ATTRIBUTE13
, FRCT.ATTRIBUTE14
, FRCT.ATTRIBUTE15
, FRCT.OLD_TRANSACTION_ID
, FRCT.TO_UPDATE
, FRCT.PROJECT_ID
, FRCT.TASK_ID
, CCICV.ITEM_COST
FROM MRP_FORECAST_DATES FRCT
, MRP_PROJECT_PARAMETERS MRP
, CST_CG_ITEM_COSTS_VIEW CCICV
WHERE FRCT.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = FRCT.ORGANIZATION_ID
AND MRP.PROJECT_ID = FRCT.PROJECT_ID
AND CCICV.ORGANIZATION_ID = FRCT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = FRCT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID UNION ALL SELECT FRCT.TRANSACTION_ID
, FRCT.LAST_UPDATE_DATE
, FRCT.LAST_UPDATED_BY
, FRCT.CREATION_DATE
, FRCT.CREATED_BY
, FRCT.LAST_UPDATE_LOGIN
, FRCT.INVENTORY_ITEM_ID
, FRCT.ORGANIZATION_ID
, FRCT.FORECAST_DESIGNATOR
, FRCT.FORECAST_DATE
, FRCT.ORIGINAL_FORECAST_QUANTITY
, FRCT.CURRENT_FORECAST_QUANTITY
, FRCT.CONFIDENCE_PERCENTAGE
, FRCT.BUCKET_TYPE
, FRCT.RATE_END_DATE
, FRCT.ORIGINATION_TYPE
, FRCT.CUSTOMER_ID
, FRCT.SHIP_ID
, FRCT.BILL_ID
, FRCT.COMMENTS
, FRCT.SOURCE_ORGANIZATION_ID
, FRCT.SOURCE_FORECAST_DESIGNATOR
, FRCT.SOURCE_CODE
, FRCT.SOURCE_LINE_ID
, FRCT.END_ITEM_ID
, FRCT.END_PLANNING_BOM_PERCENT
, FRCT.FORECAST_RULE_ID
, FRCT.DEMAND_USAGE_START_DATE
, FRCT.FORECAST_TREND
, FRCT.FOCUS_TYPE
, FRCT.FORECAST_MAD
, FRCT.DEMAND_CLASS
, FRCT.REQUEST_ID
, FRCT.PROGRAM_APPLICATION_ID
, FRCT.PROGRAM_ID
, FRCT.PROGRAM_UPDATE_DATE
, FRCT.DDF_CONTEXT
, FRCT.ATTRIBUTE_CATEGORY
, FRCT.ATTRIBUTE1
, FRCT.ATTRIBUTE2
, FRCT.ATTRIBUTE3
, FRCT.ATTRIBUTE4
, FRCT.ATTRIBUTE5
, FRCT.ATTRIBUTE6
, FRCT.ATTRIBUTE7
, FRCT.ATTRIBUTE8
, FRCT.ATTRIBUTE9
, FRCT.ATTRIBUTE10
, FRCT.ATTRIBUTE11
, FRCT.ATTRIBUTE12
, FRCT.ATTRIBUTE13
, FRCT.ATTRIBUTE14
, FRCT.ATTRIBUTE15
, FRCT.OLD_TRANSACTION_ID
, FRCT.TO_UPDATE
, FRCT.PROJECT_ID
, FRCT.TASK_ID
, 0
FROM MRP_FORECAST_DATES FRCT
, MRP_PROJECT_PARAMETERS MRP
WHERE FRCT.PROJECT_ID IS NOT NULL
AND MRP.ORGANIZATION_ID = FRCT.ORGANIZATION_ID
AND MRP.PROJECT_ID = FRCT.PROJECT_ID
AND NOT EXISTS (SELECT 'X'
FROM CST_CG_ITEM_COSTS_VIEW CCICV
WHERE CCICV.ORGANIZATION_ID = FRCT.ORGANIZATION_ID
AND CCICV.INVENTORY_ITEM_ID = FRCT.INVENTORY_ITEM_ID
AND CCICV.COST_GROUP_ID = MRP.COSTING_GROUP_ID)

Columns

Name
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
CUSTOMER_ID
SHIP_ID
BILL_ID
COMMENTS
SOURCE_ORGANIZATION_ID
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
OLD_TRANSACTION_ID
TO_UPDATE
PROJECT_ID
TASK_ID
ITEM_COST