VIEW: APPS.MTL_FORECAST_DATES_COST_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)