Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.MTL_FORECAST_DATES_COST_V |
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)