ACE_PF_SCENARIO

Details

Schema: FUSION
Object owner: ACE
Object type: VIEW

Columns

Name
SCENARIO_ID OBJECT_VERSION_NUMBER PORTFOLIO_REVISION_ID PORTFOLIO_ID STATUS IS_ENABLED CREATOR DATE_CREATED RESOURCE_VALUE_INDEX SCENARIO_BASELINE_DATE SCENARIO_DISCOUNT_RATE NET_PRESENT_VALUE INTERNAL_RATE_OF_RETURN COST_VALUE_INDEX YEAR_2_REVENUE YEAR_3_REVENUE YEAR_5_REVENUE RPI CPI TRCC ROI PAYBACK_PERIOD PORTFOLIO_RISK_SUBJECTIVE PORTFOLIO_RISK_NUMERIC PORTFOLIO_STRATEGIC_IMP ALIGNMENT IMPACT COMPETITIVE_ADVANTAGE SUPPLY_CHAIN_FIT RND_KNOW_HOW EXPECTED_COMMERCIAL_VALUE PROB_OF_COMMERCIAL_SUCCESS PROB_OF_TECHNICAL_SUCCESS ACTUAL_COST PROJECTED_COST PROJECTED_MARGIN COST_DEVIATION REVENUE_DEVIATION MARGIN_DEVIATION PROJECTED_RESOURCES ACTUAL_RESOURCES PROJECTED_REVENUE ACTUAL_REVENUE ACTUAL_MARGIN PROJ_DEV_MATERIAL_COST PROJ_DEV_VARIABLE_COST PROJ_DEV_FIXED_COST PROJ_DEV_LABOR_COST PROJ_PROD_MATERIAL_COST PROJ_PROD_VARIABLE_COST PROJ_PROD_FIXED_COST PROJ_PROD_LABOR_COST PROJ_DEV_COST PROJ_PROD_COST ACTUAL_DEV_MATERIAL_COST ACTUAL_DEV_VARIABLE_COST ACTUAL_DEV_FIXED_COST ACTUAL_DEV_LABOR_COST ACTUAL_PROD_MATERIAL_COST ACTUAL_PROD_VARIABLE_COST ACTUAL_PROD_FIXED_COST ACTUAL_PROD_LABOR_COST ACTUAL_DEVELOPMENT_COST ACTUAL_PRODUCTION_COST PORTFOLIO_STRATEGIC_FIT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_NUMBER201 EXTN_ATTRIBUTE_NUMBER202 EXTN_ATTRIBUTE_NUMBER203 EXTN_ATTRIBUTE_NUMBER204 EXTN_ATTRIBUTE_NUMBER205

Name

SCENARIO_ID

OBJECT_VERSION_NUMBER

PORTFOLIO_REVISION_ID

PORTFOLIO_ID

STATUS

IS_ENABLED

CREATOR

DATE_CREATED

RESOURCE_VALUE_INDEX

SCENARIO_BASELINE_DATE

SCENARIO_DISCOUNT_RATE

NET_PRESENT_VALUE

INTERNAL_RATE_OF_RETURN

COST_VALUE_INDEX

YEAR_2_REVENUE

YEAR_3_REVENUE

YEAR_5_REVENUE

RPI

CPI

TRCC

ROI

PAYBACK_PERIOD

PORTFOLIO_RISK_SUBJECTIVE

PORTFOLIO_RISK_NUMERIC

PORTFOLIO_STRATEGIC_IMP

ALIGNMENT

IMPACT

COMPETITIVE_ADVANTAGE

SUPPLY_CHAIN_FIT

RND_KNOW_HOW

EXPECTED_COMMERCIAL_VALUE

PROB_OF_COMMERCIAL_SUCCESS

PROB_OF_TECHNICAL_SUCCESS

ACTUAL_COST

PROJECTED_COST

PROJECTED_MARGIN

COST_DEVIATION

REVENUE_DEVIATION

MARGIN_DEVIATION

PROJECTED_RESOURCES

ACTUAL_RESOURCES

PROJECTED_REVENUE

ACTUAL_REVENUE

ACTUAL_MARGIN

PROJ_DEV_MATERIAL_COST

PROJ_DEV_VARIABLE_COST

PROJ_DEV_FIXED_COST

PROJ_DEV_LABOR_COST

PROJ_PROD_MATERIAL_COST

PROJ_PROD_VARIABLE_COST

PROJ_PROD_FIXED_COST

PROJ_PROD_LABOR_COST

PROJ_DEV_COST

PROJ_PROD_COST

ACTUAL_DEV_MATERIAL_COST

ACTUAL_DEV_VARIABLE_COST

ACTUAL_DEV_FIXED_COST

ACTUAL_DEV_LABOR_COST

ACTUAL_PROD_MATERIAL_COST

ACTUAL_PROD_VARIABLE_COST

ACTUAL_PROD_FIXED_COST

ACTUAL_PROD_LABOR_COST

ACTUAL_DEVELOPMENT_COST

ACTUAL_PRODUCTION_COST

PORTFOLIO_STRATEGIC_FIT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

NAME

DESCRIPTION

EXTN_ATTRIBUTE_TIMESTAMP001

EXTN_ATTRIBUTE_TIMESTAMP002

EXTN_ATTRIBUTE_TIMESTAMP003

EXTN_ATTRIBUTE_NUMBER001

EXTN_ATTRIBUTE_NUMBER002

EXTN_ATTRIBUTE_NUMBER003

EXTN_ATTRIBUTE_NUMBER004

EXTN_ATTRIBUTE_NUMBER005

EXTN_ATTRIBUTE_NUMBER006

EXTN_ATTRIBUTE_NUMBER007

EXTN_ATTRIBUTE_NUMBER008

EXTN_ATTRIBUTE_CHAR001

EXTN_ATTRIBUTE_CHAR002

EXTN_ATTRIBUTE_CHAR003

EXTN_ATTRIBUTE_CHAR004

EXTN_ATTRIBUTE_CHAR005

EXTN_ATTRIBUTE_CHAR006

EXTN_ATTRIBUTE_CHAR007

EXTN_ATTRIBUTE_CHAR008

EXTN_ATTRIBUTE_CHAR009

EXTN_ATTRIBUTE_CHAR010

EXTN_ATTRIBUTE_CHAR011

EXTN_ATTRIBUTE_CHAR012

EXTN_ATTRIBUTE_CHAR013

EXTN_ATTRIBUTE_CHAR014

EXTN_ATTRIBUTE_TIMESTAMP004

EXTN_ATTRIBUTE_TIMESTAMP005

EXTN_ATTRIBUTE_TIMESTAMP006

EXTN_ATTRIBUTE_NUMBER009

EXTN_ATTRIBUTE_NUMBER010

EXTN_ATTRIBUTE_NUMBER011

EXTN_ATTRIBUTE_NUMBER012

EXTN_ATTRIBUTE_NUMBER013

EXTN_ATTRIBUTE_NUMBER014

EXTN_ATTRIBUTE_NUMBER015

EXTN_ATTRIBUTE_NUMBER016

EXTN_ATTRIBUTE_CHAR015

EXTN_ATTRIBUTE_CHAR016

EXTN_ATTRIBUTE_CHAR017

EXTN_ATTRIBUTE_CHAR018

EXTN_ATTRIBUTE_CHAR019

EXTN_ATTRIBUTE_CHAR020

EXTN_ATTRIBUTE_CHAR021

EXTN_ATTRIBUTE_CHAR022

EXTN_ATTRIBUTE_CHAR023

EXTN_ATTRIBUTE_CHAR024

EXTN_ATTRIBUTE_CHAR025

EXTN_ATTRIBUTE_CHAR026

EXTN_ATTRIBUTE_CHAR027

EXTN_ATTRIBUTE_CHAR028

EXTN_ATTRIBUTE_TIMESTAMP007

EXTN_ATTRIBUTE_TIMESTAMP008

EXTN_ATTRIBUTE_TIMESTAMP009

EXTN_ATTRIBUTE_NUMBER017

EXTN_ATTRIBUTE_NUMBER018

EXTN_ATTRIBUTE_NUMBER019

EXTN_ATTRIBUTE_NUMBER020

EXTN_ATTRIBUTE_NUMBER021

EXTN_ATTRIBUTE_NUMBER022

EXTN_ATTRIBUTE_NUMBER023

EXTN_ATTRIBUTE_NUMBER024

EXTN_ATTRIBUTE_CHAR029

EXTN_ATTRIBUTE_CHAR030

EXTN_ATTRIBUTE_CHAR031

EXTN_ATTRIBUTE_CHAR032

EXTN_ATTRIBUTE_CHAR033

EXTN_ATTRIBUTE_CHAR034

EXTN_ATTRIBUTE_CHAR035

EXTN_ATTRIBUTE_CHAR036

EXTN_ATTRIBUTE_CHAR037

EXTN_ATTRIBUTE_CHAR038

EXTN_ATTRIBUTE_CHAR039

EXTN_ATTRIBUTE_CHAR040

EXTN_ATTRIBUTE_CHAR041

EXTN_ATTRIBUTE_CHAR042

EXTN_ATTRIBUTE_TIMESTAMP010

EXTN_ATTRIBUTE_TIMESTAMP011

EXTN_ATTRIBUTE_TIMESTAMP012

EXTN_ATTRIBUTE_NUMBER025

EXTN_ATTRIBUTE_NUMBER026

EXTN_ATTRIBUTE_NUMBER027

EXTN_ATTRIBUTE_NUMBER028

EXTN_ATTRIBUTE_NUMBER029

EXTN_ATTRIBUTE_NUMBER030

EXTN_ATTRIBUTE_NUMBER031

EXTN_ATTRIBUTE_NUMBER032

EXTN_ATTRIBUTE_CHAR043

EXTN_ATTRIBUTE_CHAR044

EXTN_ATTRIBUTE_CHAR045

EXTN_ATTRIBUTE_CHAR046

EXTN_ATTRIBUTE_CHAR047

EXTN_ATTRIBUTE_CHAR048

EXTN_ATTRIBUTE_CHAR049

EXTN_ATTRIBUTE_CHAR050

EXTN_ATTRIBUTE_CHAR051

EXTN_ATTRIBUTE_CHAR052

EXTN_ATTRIBUTE_CHAR053

EXTN_ATTRIBUTE_CHAR054

EXTN_ATTRIBUTE_CHAR055

EXTN_ATTRIBUTE_CHAR056

EXTN_ATTRIBUTE_TIMESTAMP013

EXTN_ATTRIBUTE_TIMESTAMP014

EXTN_ATTRIBUTE_TIMESTAMP015

EXTN_ATTRIBUTE_NUMBER033

EXTN_ATTRIBUTE_NUMBER034

EXTN_ATTRIBUTE_NUMBER035

EXTN_ATTRIBUTE_NUMBER036

EXTN_ATTRIBUTE_NUMBER037

EXTN_ATTRIBUTE_NUMBER038

EXTN_ATTRIBUTE_NUMBER039

EXTN_ATTRIBUTE_NUMBER040

EXTN_ATTRIBUTE_CHAR057

EXTN_ATTRIBUTE_CHAR058

EXTN_ATTRIBUTE_CHAR059

EXTN_ATTRIBUTE_CHAR060

EXTN_ATTRIBUTE_CHAR061

EXTN_ATTRIBUTE_CHAR062

EXTN_ATTRIBUTE_CHAR063

EXTN_ATTRIBUTE_CHAR064

EXTN_ATTRIBUTE_CHAR065

EXTN_ATTRIBUTE_CHAR066

EXTN_ATTRIBUTE_CHAR067

EXTN_ATTRIBUTE_CHAR068

EXTN_ATTRIBUTE_CHAR069

EXTN_ATTRIBUTE_CHAR070

EXTN_ATTRIBUTE_TIMESTAMP016

EXTN_ATTRIBUTE_TIMESTAMP017

EXTN_ATTRIBUTE_TIMESTAMP018

EXTN_ATTRIBUTE_NUMBER041

EXTN_ATTRIBUTE_NUMBER042

EXTN_ATTRIBUTE_NUMBER043

EXTN_ATTRIBUTE_NUMBER044

EXTN_ATTRIBUTE_NUMBER045

EXTN_ATTRIBUTE_NUMBER046

EXTN_ATTRIBUTE_NUMBER047

EXTN_ATTRIBUTE_NUMBER048

EXTN_ATTRIBUTE_CHAR071

EXTN_ATTRIBUTE_CHAR072

EXTN_ATTRIBUTE_CHAR073

EXTN_ATTRIBUTE_CHAR074

EXTN_ATTRIBUTE_CHAR075

EXTN_ATTRIBUTE_CHAR076

EXTN_ATTRIBUTE_CHAR077

EXTN_ATTRIBUTE_CHAR078

EXTN_ATTRIBUTE_CHAR079

EXTN_ATTRIBUTE_CHAR080

EXTN_ATTRIBUTE_CHAR081

EXTN_ATTRIBUTE_CHAR082

EXTN_ATTRIBUTE_CHAR083

EXTN_ATTRIBUTE_CHAR084

EXTN_ATTRIBUTE_TIMESTAMP019

EXTN_ATTRIBUTE_TIMESTAMP020

EXTN_ATTRIBUTE_NUMBER049

EXTN_ATTRIBUTE_NUMBER050

EXTN_ATTRIBUTE_CHAR085

EXTN_ATTRIBUTE_CHAR086

EXTN_ATTRIBUTE_CHAR087

EXTN_ATTRIBUTE_CHAR088

EXTN_ATTRIBUTE_CHAR089

EXTN_ATTRIBUTE_CHAR090

EXTN_ATTRIBUTE_CHAR091

EXTN_ATTRIBUTE_CHAR092

EXTN_ATTRIBUTE_CHAR093

EXTN_ATTRIBUTE_CHAR094

EXTN_ATTRIBUTE_CHAR095

EXTN_ATTRIBUTE_CHAR096

EXTN_ATTRIBUTE_CHAR097

EXTN_ATTRIBUTE_CHAR098

EXTN_ATTRIBUTE_CHAR099

EXTN_ATTRIBUTE_CHAR100

EXTN_ATTRIBUTE_NUMBER201

EXTN_ATTRIBUTE_NUMBER202

EXTN_ATTRIBUTE_NUMBER203

EXTN_ATTRIBUTE_NUMBER204

EXTN_ATTRIBUTE_NUMBER205

Query

SQL_Statement
SELECT ACE_PF_SCENARIO_B.SCENARIO_ID SCENARIO_ID, ACE_PF_SCENARIO_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACE_PF_SCENARIO_B.PORTFOLIO_REVISION_ID PORTFOLIO_REVISION_ID, ACE_PF_SCENARIO_B.PORTFOLIO_ID PORTFOLIO_ID, ACE_PF_SCENARIO_B.STATUS STATUS, ACE_PF_SCENARIO_B.IS_ENABLED IS_ENABLED, ACE_PF_SCENARIO_B.CREATOR CREATOR, ACE_PF_SCENARIO_B.DATE_CREATED DATE_CREATED, ACE_PF_SCENARIO_B.RESOURCE_VALUE_INDEX RESOURCE_VALUE_INDEX, ACE_PF_SCENARIO_B.SCENARIO_BASELINE_DATE SCENARIO_BASELINE_DATE, ACE_PF_SCENARIO_B.SCENARIO_DISCOUNT_RATE SCENARIO_DISCOUNT_RATE, ACE_PF_SCENARIO_B.NET_PRESENT_VALUE NET_PRESENT_VALUE, ACE_PF_SCENARIO_B.INTERNAL_RATE_OF_RETURN INTERNAL_RATE_OF_RETURN, ACE_PF_SCENARIO_B.COST_VALUE_INDEX COST_VALUE_INDEX, ACE_PF_SCENARIO_B.YEAR_2_REVENUE YEAR_2_REVENUE, ACE_PF_SCENARIO_B.YEAR_3_REVENUE YEAR_3_REVENUE, ACE_PF_SCENARIO_B.YEAR_5_REVENUE YEAR_5_REVENUE, ACE_PF_SCENARIO_B.RPI RPI, ACE_PF_SCENARIO_B.CPI CPI, ACE_PF_SCENARIO_B.TRCC TRCC, ACE_PF_SCENARIO_B.ROI ROI, ACE_PF_SCENARIO_B.PAYBACK_PERIOD PAYBACK_PERIOD, ACE_PF_SCENARIO_B.PORTFOLIO_RISK_SUBJECTIVE PORTFOLIO_RISK_SUBJECTIVE, ACE_PF_SCENARIO_B.PORTFOLIO_RISK_NUMERIC PORTFOLIO_RISK_NUMERIC, ACE_PF_SCENARIO_B.PORTFOLIO_STRATEGIC_IMP PORTFOLIO_STRATEGIC_IMP, ACE_PF_SCENARIO_B.ALIGNMENT ALIGNMENT, ACE_PF_SCENARIO_B.IMPACT IMPACT, ACE_PF_SCENARIO_B.COMPETITIVE_ADVANTAGE COMPETITIVE_ADVANTAGE, ACE_PF_SCENARIO_B.SUPPLY_CHAIN_FIT SUPPLY_CHAIN_FIT, ACE_PF_SCENARIO_B.RND_KNOW_HOW RND_KNOW_HOW, ACE_PF_SCENARIO_B.EXPECTED_COMMERCIAL_VALUE EXPECTED_COMMERCIAL_VALUE, ACE_PF_SCENARIO_B.PROB_OF_COMMERCIAL_SUCCESS PROB_OF_COMMERCIAL_SUCCESS, ACE_PF_SCENARIO_B.PROB_OF_TECHNICAL_SUCCESS PROB_OF_TECHNICAL_SUCCESS, ACE_PF_SCENARIO_B.ACTUAL_COST ACTUAL_COST, ACE_PF_SCENARIO_B.PROJECTED_COST PROJECTED_COST, ACE_PF_SCENARIO_B.PROJECTED_MARGIN PROJECTED_MARGIN, ACE_PF_SCENARIO_B.COST_DEVIATION COST_DEVIATION, ACE_PF_SCENARIO_B.REVENUE_DEVIATION REVENUE_DEVIATION, ACE_PF_SCENARIO_B.MARGIN_DEVIATION MARGIN_DEVIATION, ACE_PF_SCENARIO_B.PROJECTED_RESOURCES PROJECTED_RESOURCES, ACE_PF_SCENARIO_B.ACTUAL_RESOURCES ACTUAL_RESOURCES, ACE_PF_SCENARIO_B.PROJECTED_REVENUE PROJECTED_REVENUE, ACE_PF_SCENARIO_B.ACTUAL_REVENUE ACTUAL_REVENUE, ACE_PF_SCENARIO_B.ACTUAL_MARGIN ACTUAL_MARGIN, ACE_PF_SCENARIO_B.PROJ_DEV_MATERIAL_COST PROJ_DEV_MATERIAL_COST, ACE_PF_SCENARIO_B.PROJ_DEV_VARIABLE_COST PROJ_DEV_VARIABLE_COST, ACE_PF_SCENARIO_B.PROJ_DEV_FIXED_COST PROJ_DEV_FIXED_COST, ACE_PF_SCENARIO_B.PROJ_DEV_LABOR_COST PROJ_DEV_LABOR_COST, ACE_PF_SCENARIO_B.PROJ_PROD_MATERIAL_COST PROJ_PROD_MATERIAL_COST, ACE_PF_SCENARIO_B.PROJ_PROD_VARIABLE_COST PROJ_PROD_VARIABLE_COST, ACE_PF_SCENARIO_B.PROJ_PROD_FIXED_COST PROJ_PROD_FIXED_COST, ACE_PF_SCENARIO_B.PROJ_PROD_LABOR_COST PROJ_PROD_LABOR_COST, ACE_PF_SCENARIO_B.PROJ_DEV_COST PROJ_DEV_COST, ACE_PF_SCENARIO_B.PROJ_PROD_COST PROJ_PROD_COST, ACE_PF_SCENARIO_B.ACTUAL_DEV_MATERIAL_COST ACTUAL_DEV_MATERIAL_COST, ACE_PF_SCENARIO_B.ACTUAL_DEV_VARIABLE_COST ACTUAL_DEV_VARIABLE_COST, ACE_PF_SCENARIO_B.ACTUAL_DEV_FIXED_COST ACTUAL_DEV_FIXED_COST, ACE_PF_SCENARIO_B.ACTUAL_DEV_LABOR_COST ACTUAL_DEV_LABOR_COST, ACE_PF_SCENARIO_B.ACTUAL_PROD_MATERIAL_COST ACTUAL_PROD_MATERIAL_COST, ACE_PF_SCENARIO_B.ACTUAL_PROD_VARIABLE_COST ACTUAL_PROD_VARIABLE_COST, ACE_PF_SCENARIO_B.ACTUAL_PROD_FIXED_COST ACTUAL_PROD_FIXED_COST, ACE_PF_SCENARIO_B.ACTUAL_PROD_LABOR_COST ACTUAL_PROD_LABOR_COST, ACE_PF_SCENARIO_B.ACTUAL_DEVELOPMENT_COST ACTUAL_DEVELOPMENT_COST, ACE_PF_SCENARIO_B.ACTUAL_PRODUCTION_COST ACTUAL_PRODUCTION_COST, ACE_PF_SCENARIO_B.PORTFOLIO_STRATEGIC_FIT PORTFOLIO_STRATEGIC_FIT, ACE_PF_SCENARIO_B.CREATED_BY CREATED_BY, ACE_PF_SCENARIO_B.CREATION_DATE CREATION_DATE, ACE_PF_SCENARIO_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACE_PF_SCENARIO_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACE_PF_SCENARIO_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACE_PF_SCENARIO_TL.NAME NAME, ACE_PF_SCENARIO_TL.DESCRIPTION DESCRIPTION, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP011, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_TIMESTAMP012, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP013, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP014, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_TIMESTAMP015, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP016, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP017, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_TIMESTAMP018, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP019, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_TIMESTAMP020, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER201 EXTN_ATTRIBUTE_NUMBER201, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER202 EXTN_ATTRIBUTE_NUMBER202, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER203 EXTN_ATTRIBUTE_NUMBER203, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER204 EXTN_ATTRIBUTE_NUMBER204, ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER205 EXTN_ATTRIBUTE_NUMBER205 FROM ACE_PF_SCENARIO_B, ACE_PF_SCENARIO_TL WHERE ACE_PF_SCENARIO_B.SCENARIO_ID = ACE_PF_SCENARIO_TL.SCENARIO_ID AND ACE_PF_SCENARIO_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ACE_PF_SCENARIO_B.SCENARIO_ID SCENARIO_ID,

ACE_PF_SCENARIO_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ACE_PF_SCENARIO_B.PORTFOLIO_REVISION_ID PORTFOLIO_REVISION_ID,

ACE_PF_SCENARIO_B.PORTFOLIO_ID PORTFOLIO_ID,

ACE_PF_SCENARIO_B.STATUS STATUS,

ACE_PF_SCENARIO_B.IS_ENABLED IS_ENABLED,

ACE_PF_SCENARIO_B.CREATOR CREATOR,

ACE_PF_SCENARIO_B.DATE_CREATED DATE_CREATED,

ACE_PF_SCENARIO_B.RESOURCE_VALUE_INDEX RESOURCE_VALUE_INDEX,

ACE_PF_SCENARIO_B.SCENARIO_BASELINE_DATE SCENARIO_BASELINE_DATE,

ACE_PF_SCENARIO_B.SCENARIO_DISCOUNT_RATE SCENARIO_DISCOUNT_RATE,

ACE_PF_SCENARIO_B.NET_PRESENT_VALUE NET_PRESENT_VALUE,

ACE_PF_SCENARIO_B.INTERNAL_RATE_OF_RETURN INTERNAL_RATE_OF_RETURN,

ACE_PF_SCENARIO_B.COST_VALUE_INDEX COST_VALUE_INDEX,

ACE_PF_SCENARIO_B.YEAR_2_REVENUE YEAR_2_REVENUE,

ACE_PF_SCENARIO_B.YEAR_3_REVENUE YEAR_3_REVENUE,

ACE_PF_SCENARIO_B.YEAR_5_REVENUE YEAR_5_REVENUE,

ACE_PF_SCENARIO_B.RPI RPI,

ACE_PF_SCENARIO_B.CPI CPI,

ACE_PF_SCENARIO_B.TRCC TRCC,

ACE_PF_SCENARIO_B.ROI ROI,

ACE_PF_SCENARIO_B.PAYBACK_PERIOD PAYBACK_PERIOD,

ACE_PF_SCENARIO_B.PORTFOLIO_RISK_SUBJECTIVE PORTFOLIO_RISK_SUBJECTIVE,

ACE_PF_SCENARIO_B.PORTFOLIO_RISK_NUMERIC PORTFOLIO_RISK_NUMERIC,

ACE_PF_SCENARIO_B.PORTFOLIO_STRATEGIC_IMP PORTFOLIO_STRATEGIC_IMP,

ACE_PF_SCENARIO_B.ALIGNMENT ALIGNMENT,

ACE_PF_SCENARIO_B.IMPACT IMPACT,

ACE_PF_SCENARIO_B.COMPETITIVE_ADVANTAGE COMPETITIVE_ADVANTAGE,

ACE_PF_SCENARIO_B.SUPPLY_CHAIN_FIT SUPPLY_CHAIN_FIT,

ACE_PF_SCENARIO_B.RND_KNOW_HOW RND_KNOW_HOW,

ACE_PF_SCENARIO_B.EXPECTED_COMMERCIAL_VALUE EXPECTED_COMMERCIAL_VALUE,

ACE_PF_SCENARIO_B.PROB_OF_COMMERCIAL_SUCCESS PROB_OF_COMMERCIAL_SUCCESS,

ACE_PF_SCENARIO_B.PROB_OF_TECHNICAL_SUCCESS PROB_OF_TECHNICAL_SUCCESS,

ACE_PF_SCENARIO_B.ACTUAL_COST ACTUAL_COST,

ACE_PF_SCENARIO_B.PROJECTED_COST PROJECTED_COST,

ACE_PF_SCENARIO_B.PROJECTED_MARGIN PROJECTED_MARGIN,

ACE_PF_SCENARIO_B.COST_DEVIATION COST_DEVIATION,

ACE_PF_SCENARIO_B.REVENUE_DEVIATION REVENUE_DEVIATION,

ACE_PF_SCENARIO_B.MARGIN_DEVIATION MARGIN_DEVIATION,

ACE_PF_SCENARIO_B.PROJECTED_RESOURCES PROJECTED_RESOURCES,

ACE_PF_SCENARIO_B.ACTUAL_RESOURCES ACTUAL_RESOURCES,

ACE_PF_SCENARIO_B.PROJECTED_REVENUE PROJECTED_REVENUE,

ACE_PF_SCENARIO_B.ACTUAL_REVENUE ACTUAL_REVENUE,

ACE_PF_SCENARIO_B.ACTUAL_MARGIN ACTUAL_MARGIN,

ACE_PF_SCENARIO_B.PROJ_DEV_MATERIAL_COST PROJ_DEV_MATERIAL_COST,

ACE_PF_SCENARIO_B.PROJ_DEV_VARIABLE_COST PROJ_DEV_VARIABLE_COST,

ACE_PF_SCENARIO_B.PROJ_DEV_FIXED_COST PROJ_DEV_FIXED_COST,

ACE_PF_SCENARIO_B.PROJ_DEV_LABOR_COST PROJ_DEV_LABOR_COST,

ACE_PF_SCENARIO_B.PROJ_PROD_MATERIAL_COST PROJ_PROD_MATERIAL_COST,

ACE_PF_SCENARIO_B.PROJ_PROD_VARIABLE_COST PROJ_PROD_VARIABLE_COST,

ACE_PF_SCENARIO_B.PROJ_PROD_FIXED_COST PROJ_PROD_FIXED_COST,

ACE_PF_SCENARIO_B.PROJ_PROD_LABOR_COST PROJ_PROD_LABOR_COST,

ACE_PF_SCENARIO_B.PROJ_DEV_COST PROJ_DEV_COST,

ACE_PF_SCENARIO_B.PROJ_PROD_COST PROJ_PROD_COST,

ACE_PF_SCENARIO_B.ACTUAL_DEV_MATERIAL_COST ACTUAL_DEV_MATERIAL_COST,

ACE_PF_SCENARIO_B.ACTUAL_DEV_VARIABLE_COST ACTUAL_DEV_VARIABLE_COST,

ACE_PF_SCENARIO_B.ACTUAL_DEV_FIXED_COST ACTUAL_DEV_FIXED_COST,

ACE_PF_SCENARIO_B.ACTUAL_DEV_LABOR_COST ACTUAL_DEV_LABOR_COST,

ACE_PF_SCENARIO_B.ACTUAL_PROD_MATERIAL_COST ACTUAL_PROD_MATERIAL_COST,

ACE_PF_SCENARIO_B.ACTUAL_PROD_VARIABLE_COST ACTUAL_PROD_VARIABLE_COST,

ACE_PF_SCENARIO_B.ACTUAL_PROD_FIXED_COST ACTUAL_PROD_FIXED_COST,

ACE_PF_SCENARIO_B.ACTUAL_PROD_LABOR_COST ACTUAL_PROD_LABOR_COST,

ACE_PF_SCENARIO_B.ACTUAL_DEVELOPMENT_COST ACTUAL_DEVELOPMENT_COST,

ACE_PF_SCENARIO_B.ACTUAL_PRODUCTION_COST ACTUAL_PRODUCTION_COST,

ACE_PF_SCENARIO_B.PORTFOLIO_STRATEGIC_FIT PORTFOLIO_STRATEGIC_FIT,

ACE_PF_SCENARIO_B.CREATED_BY CREATED_BY,

ACE_PF_SCENARIO_B.CREATION_DATE CREATION_DATE,

ACE_PF_SCENARIO_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ACE_PF_SCENARIO_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ACE_PF_SCENARIO_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ACE_PF_SCENARIO_TL.NAME NAME,

ACE_PF_SCENARIO_TL.DESCRIPTION DESCRIPTION,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP011 EXTN_ATTRIBUTE_TIMESTAMP011,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP012 EXTN_ATTRIBUTE_TIMESTAMP012,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP013 EXTN_ATTRIBUTE_TIMESTAMP013,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP014 EXTN_ATTRIBUTE_TIMESTAMP014,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP015 EXTN_ATTRIBUTE_TIMESTAMP015,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP016 EXTN_ATTRIBUTE_TIMESTAMP016,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP017 EXTN_ATTRIBUTE_TIMESTAMP017,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP018 EXTN_ATTRIBUTE_TIMESTAMP018,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP019 EXTN_ATTRIBUTE_TIMESTAMP019,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_TIMESTAMP020 EXTN_ATTRIBUTE_TIMESTAMP020,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER201 EXTN_ATTRIBUTE_NUMBER201,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER202 EXTN_ATTRIBUTE_NUMBER202,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER203 EXTN_ATTRIBUTE_NUMBER203,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER204 EXTN_ATTRIBUTE_NUMBER204,

ACE_PF_SCENARIO_B.EXTN_ATTRIBUTE_NUMBER205 EXTN_ATTRIBUTE_NUMBER205

FROM

ACE_PF_SCENARIO_B,

ACE_PF_SCENARIO_TL

WHERE

ACE_PF_SCENARIO_B.SCENARIO_ID = ACE_PF_SCENARIO_TL.SCENARIO_ID AND ACE_PF_SCENARIO_TL.LANGUAGE = USERENV('LANG')