ACD_BUSINESS_DETAILS

Details

Schema: FUSION
Object owner: ACD
Object type: VIEW

Columns

Name
BUSINESS_DETAIL_ID OBJECT_VERSION_NUMBER PRODUCT_PROPOSAL_ID DISCOUNT_RATE TARGET_COST AVERAGE_SELLING_PRICE FUNDING_REQUEST_FOR FUNDING_AMOUNT BUSINESS_UNIT PRODUCT_LINE PRIMARY_JUSTIFICATION SECONDARY_JUSTIFICATION ALLOCATED_BUDGET REQUIREMENTS_DEFINITION HIGH_LEVEL_DESIGN DEVELOPMENT_START DEVELOPMENT_END LAUNCH ACTUAL_LAUNCH EOL BUSINESS_OBJECTIVES PROPOSAL_VERSION_NOTES SUMMARY NET_PRESENT_VALUE INTERNAL_RATE_OF_RETURN RETURN_ON_INVESTMENT BREAK_EVEN_TIME PROPOSAL_PROJECTED_COST PROPOSAL_PROJECTED_REVENUE BASELINE_DATE EXPECTED_COMMERCIAL_VALUE ACTUAL_RESOURCES PROJECTED_RESOURCES ACTUAL_REVENUE RISK_SUBJECTIVE RISK_NUMBERIC PRODUCT_STRATEGIC_FIT 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 PROB_OF_COMMERCIAL_SUCCESS PROB_OF_TECHNICAL_SUCCESS RESOURCE_VALUE_INDEX COST_VALUE_INDEX ACTUAL_COST YEAR_2_REVENUE YEAR_3_REVENUE YEAR_5_REVENUE RPI CPI PAYBACK_PERIOD MARKET_GROWTH_PERCENT MARKET_SHARE_PERCENT PRODUCT_CATEGORIZATION ALIGNMENT IMPACT COMPETITIVE_ADVANTAGE SUPPLY_CHAIN_FIT RND_KNOW_HOW BUSINESS_UNIT_STRENGTH MARKET_ATTRACTIVENESS PROJECTED_MARGIN ACTUAL_MARGIN CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MARKET_STRATEGY

Name

BUSINESS_DETAIL_ID

OBJECT_VERSION_NUMBER

PRODUCT_PROPOSAL_ID

DISCOUNT_RATE

TARGET_COST

AVERAGE_SELLING_PRICE

FUNDING_REQUEST_FOR

FUNDING_AMOUNT

BUSINESS_UNIT

PRODUCT_LINE

PRIMARY_JUSTIFICATION

SECONDARY_JUSTIFICATION

ALLOCATED_BUDGET

REQUIREMENTS_DEFINITION

HIGH_LEVEL_DESIGN

DEVELOPMENT_START

DEVELOPMENT_END

LAUNCH

ACTUAL_LAUNCH

EOL

BUSINESS_OBJECTIVES

PROPOSAL_VERSION_NOTES

SUMMARY

NET_PRESENT_VALUE

INTERNAL_RATE_OF_RETURN

RETURN_ON_INVESTMENT

BREAK_EVEN_TIME

PROPOSAL_PROJECTED_COST

PROPOSAL_PROJECTED_REVENUE

BASELINE_DATE

EXPECTED_COMMERCIAL_VALUE

ACTUAL_RESOURCES

PROJECTED_RESOURCES

ACTUAL_REVENUE

RISK_SUBJECTIVE

RISK_NUMBERIC

PRODUCT_STRATEGIC_FIT

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

PROB_OF_COMMERCIAL_SUCCESS

PROB_OF_TECHNICAL_SUCCESS

RESOURCE_VALUE_INDEX

COST_VALUE_INDEX

ACTUAL_COST

YEAR_2_REVENUE

YEAR_3_REVENUE

YEAR_5_REVENUE

RPI

CPI

PAYBACK_PERIOD

MARKET_GROWTH_PERCENT

MARKET_SHARE_PERCENT

PRODUCT_CATEGORIZATION

ALIGNMENT

IMPACT

COMPETITIVE_ADVANTAGE

SUPPLY_CHAIN_FIT

RND_KNOW_HOW

BUSINESS_UNIT_STRENGTH

MARKET_ATTRACTIVENESS

PROJECTED_MARGIN

ACTUAL_MARGIN

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

MARKET_STRATEGY

Query

SQL_Statement
SELECT ACD_BUSINESS_DETAILS_B.BUSINESS_DETAIL_ID BUSINESS_DETAIL_ID, ACD_BUSINESS_DETAILS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACD_BUSINESS_DETAILS_B.PRODUCT_PROPOSAL_ID PRODUCT_PROPOSAL_ID, ACD_BUSINESS_DETAILS_B.DISCOUNT_RATE DISCOUNT_RATE, ACD_BUSINESS_DETAILS_B.TARGET_COST TARGET_COST, ACD_BUSINESS_DETAILS_B.AVERAGE_SELLING_PRICE AVERAGE_SELLING_PRICE, ACD_BUSINESS_DETAILS_B.FUNDING_REQUEST_FOR FUNDING_REQUEST_FOR, ACD_BUSINESS_DETAILS_B.FUNDING_AMOUNT FUNDING_AMOUNT, ACD_BUSINESS_DETAILS_B.BUSINESS_UNIT BUSINESS_UNIT, ACD_BUSINESS_DETAILS_B.PRODUCT_LINE PRODUCT_LINE, ACD_BUSINESS_DETAILS_B.PRIMARY_JUSTIFICATION PRIMARY_JUSTIFICATION, ACD_BUSINESS_DETAILS_B.SECONDARY_JUSTIFICATION SECONDARY_JUSTIFICATION, ACD_BUSINESS_DETAILS_B.ALLOCATED_BUDGET ALLOCATED_BUDGET, ACD_BUSINESS_DETAILS_B.REQUIREMENTS_DEFINITION REQUIREMENTS_DEFINITION, ACD_BUSINESS_DETAILS_B.HIGH_LEVEL_DESIGN HIGH_LEVEL_DESIGN, ACD_BUSINESS_DETAILS_B.DEVELOPMENT_START DEVELOPMENT_START, ACD_BUSINESS_DETAILS_B.DEVELOPMENT_END DEVELOPMENT_END, ACD_BUSINESS_DETAILS_B.LAUNCH LAUNCH, ACD_BUSINESS_DETAILS_B.ACTUAL_LAUNCH ACTUAL_LAUNCH, ACD_BUSINESS_DETAILS_B.EOL EOL, ACD_BUSINESS_DETAILS_TL.BUSINESS_OBJECTIVES BUSINESS_OBJECTIVES, ACD_BUSINESS_DETAILS_TL.PROPOSAL_VERSION_NOTES PROPOSAL_VERSION_NOTES, ACD_BUSINESS_DETAILS_B.SUMMARY SUMMARY, ACD_BUSINESS_DETAILS_B.NET_PRESENT_VALUE NET_PRESENT_VALUE, ACD_BUSINESS_DETAILS_B.INTERNAL_RATE_OF_RETURN INTERNAL_RATE_OF_RETURN, ACD_BUSINESS_DETAILS_B.RETURN_ON_INVESTMENT RETURN_ON_INVESTMENT, ACD_BUSINESS_DETAILS_B.BREAK_EVEN_TIME BREAK_EVEN_TIME, ACD_BUSINESS_DETAILS_B.PROPOSAL_PROJECTED_COST PROPOSAL_PROJECTED_COST, ACD_BUSINESS_DETAILS_B.PROPOSAL_PROJECTED_REVENUE PROPOSAL_PROJECTED_REVENUE, ACD_BUSINESS_DETAILS_B.BASELINE_DATE BASELINE_DATE, ACD_BUSINESS_DETAILS_B.EXPECTED_COMMERCIAL_VALUE, ACD_BUSINESS_DETAILS_B.ACTUAL_RESOURCES, ACD_BUSINESS_DETAILS_B.PROJECTED_RESOURCES, ACD_BUSINESS_DETAILS_B.ACTUAL_REVENUE, ACD_BUSINESS_DETAILS_B.RISK_SUBJECTIVE, ACD_BUSINESS_DETAILS_B.RISK_NUMBERIC, ACD_BUSINESS_DETAILS_B.PRODUCT_STRATEGIC_FIT, ACD_BUSINESS_DETAILS_B.PROJ_DEV_MATERIAL_COST, ACD_BUSINESS_DETAILS_B.PROJ_DEV_VARIABLE_COST, ACD_BUSINESS_DETAILS_B.PROJ_DEV_FIXED_COST, ACD_BUSINESS_DETAILS_B.PROJ_DEV_LABOR_COST, ACD_BUSINESS_DETAILS_B.PROJ_PROD_MATERIAL_COST, ACD_BUSINESS_DETAILS_B.PROJ_PROD_VARIABLE_COST, ACD_BUSINESS_DETAILS_B.PROJ_PROD_FIXED_COST, ACD_BUSINESS_DETAILS_B.PROJ_PROD_LABOR_COST, ACD_BUSINESS_DETAILS_B.PROJ_DEV_COST, ACD_BUSINESS_DETAILS_B.PROJ_PROD_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_MATERIAL_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_VARIABLE_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_FIXED_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_LABOR_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_MATERIAL_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_VARIABLE_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_FIXED_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_LABOR_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_DEVELOPMENT_COST, ACD_BUSINESS_DETAILS_B.ACTUAL_PRODUCTION_COST, ACD_BUSINESS_DETAILS_B.PROB_OF_COMMERCIAL_SUCCESS, ACD_BUSINESS_DETAILS_B.PROB_OF_TECHNICAL_SUCCESS, ACD_BUSINESS_DETAILS_B.RESOURCE_VALUE_INDEX, ACD_BUSINESS_DETAILS_B.COST_VALUE_INDEX, ACD_BUSINESS_DETAILS_B.ACTUAL_COST, ACD_BUSINESS_DETAILS_B.YEAR_2_REVENUE, ACD_BUSINESS_DETAILS_B.YEAR_3_REVENUE, ACD_BUSINESS_DETAILS_B.YEAR_5_REVENUE, ACD_BUSINESS_DETAILS_B.RPI, ACD_BUSINESS_DETAILS_B.CPI, ACD_BUSINESS_DETAILS_B.PAYBACK_PERIOD, ACD_BUSINESS_DETAILS_B.MARKET_GROWTH_PERCENT, ACD_BUSINESS_DETAILS_B.MARKET_SHARE_PERCENT, ACD_BUSINESS_DETAILS_B.PRODUCT_CATEGORIZATION, ACD_BUSINESS_DETAILS_B.ALIGNMENT, ACD_BUSINESS_DETAILS_B.IMPACT, ACD_BUSINESS_DETAILS_B.COMPETITIVE_ADVANTAGE, ACD_BUSINESS_DETAILS_B.SUPPLY_CHAIN_FIT, ACD_BUSINESS_DETAILS_B.RND_KNOW_HOW, ACD_BUSINESS_DETAILS_B.BUSINESS_UNIT_STRENGTH, ACD_BUSINESS_DETAILS_B.MARKET_ATTRACTIVENESS, ACD_BUSINESS_DETAILS_B.PROJECTED_MARGIN, ACD_BUSINESS_DETAILS_B.ACTUAL_MARGIN, ACD_BUSINESS_DETAILS_B.CREATED_BY CREATED_BY, ACD_BUSINESS_DETAILS_B.CREATION_DATE CREATION_DATE, ACD_BUSINESS_DETAILS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACD_BUSINESS_DETAILS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACD_BUSINESS_DETAILS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACD_BUSINESS_DETAILS_B.MARKET_STRATEGY MARKET_STRATEGY FROM ACD_BUSINESS_DETAILS_B, ACD_BUSINESS_DETAILS_TL WHERE ACD_BUSINESS_DETAILS_B.BUSINESS_DETAIL_ID = ACD_BUSINESS_DETAILS_TL.BUSINESS_DETAIL_ID AND ACD_BUSINESS_DETAILS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ACD_BUSINESS_DETAILS_B.BUSINESS_DETAIL_ID BUSINESS_DETAIL_ID,

ACD_BUSINESS_DETAILS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ACD_BUSINESS_DETAILS_B.PRODUCT_PROPOSAL_ID PRODUCT_PROPOSAL_ID,

ACD_BUSINESS_DETAILS_B.DISCOUNT_RATE DISCOUNT_RATE,

ACD_BUSINESS_DETAILS_B.TARGET_COST TARGET_COST,

ACD_BUSINESS_DETAILS_B.AVERAGE_SELLING_PRICE AVERAGE_SELLING_PRICE,

ACD_BUSINESS_DETAILS_B.FUNDING_REQUEST_FOR FUNDING_REQUEST_FOR,

ACD_BUSINESS_DETAILS_B.FUNDING_AMOUNT FUNDING_AMOUNT,

ACD_BUSINESS_DETAILS_B.BUSINESS_UNIT BUSINESS_UNIT,

ACD_BUSINESS_DETAILS_B.PRODUCT_LINE PRODUCT_LINE,

ACD_BUSINESS_DETAILS_B.PRIMARY_JUSTIFICATION PRIMARY_JUSTIFICATION,

ACD_BUSINESS_DETAILS_B.SECONDARY_JUSTIFICATION SECONDARY_JUSTIFICATION,

ACD_BUSINESS_DETAILS_B.ALLOCATED_BUDGET ALLOCATED_BUDGET,

ACD_BUSINESS_DETAILS_B.REQUIREMENTS_DEFINITION REQUIREMENTS_DEFINITION,

ACD_BUSINESS_DETAILS_B.HIGH_LEVEL_DESIGN HIGH_LEVEL_DESIGN,

ACD_BUSINESS_DETAILS_B.DEVELOPMENT_START DEVELOPMENT_START,

ACD_BUSINESS_DETAILS_B.DEVELOPMENT_END DEVELOPMENT_END,

ACD_BUSINESS_DETAILS_B.LAUNCH LAUNCH,

ACD_BUSINESS_DETAILS_B.ACTUAL_LAUNCH ACTUAL_LAUNCH,

ACD_BUSINESS_DETAILS_B.EOL EOL,

ACD_BUSINESS_DETAILS_TL.BUSINESS_OBJECTIVES BUSINESS_OBJECTIVES,

ACD_BUSINESS_DETAILS_TL.PROPOSAL_VERSION_NOTES PROPOSAL_VERSION_NOTES,

ACD_BUSINESS_DETAILS_B.SUMMARY SUMMARY,

ACD_BUSINESS_DETAILS_B.NET_PRESENT_VALUE NET_PRESENT_VALUE,

ACD_BUSINESS_DETAILS_B.INTERNAL_RATE_OF_RETURN INTERNAL_RATE_OF_RETURN,

ACD_BUSINESS_DETAILS_B.RETURN_ON_INVESTMENT RETURN_ON_INVESTMENT,

ACD_BUSINESS_DETAILS_B.BREAK_EVEN_TIME BREAK_EVEN_TIME,

ACD_BUSINESS_DETAILS_B.PROPOSAL_PROJECTED_COST PROPOSAL_PROJECTED_COST,

ACD_BUSINESS_DETAILS_B.PROPOSAL_PROJECTED_REVENUE PROPOSAL_PROJECTED_REVENUE,

ACD_BUSINESS_DETAILS_B.BASELINE_DATE BASELINE_DATE,

ACD_BUSINESS_DETAILS_B.EXPECTED_COMMERCIAL_VALUE,

ACD_BUSINESS_DETAILS_B.ACTUAL_RESOURCES,

ACD_BUSINESS_DETAILS_B.PROJECTED_RESOURCES,

ACD_BUSINESS_DETAILS_B.ACTUAL_REVENUE,

ACD_BUSINESS_DETAILS_B.RISK_SUBJECTIVE,

ACD_BUSINESS_DETAILS_B.RISK_NUMBERIC,

ACD_BUSINESS_DETAILS_B.PRODUCT_STRATEGIC_FIT,

ACD_BUSINESS_DETAILS_B.PROJ_DEV_MATERIAL_COST,

ACD_BUSINESS_DETAILS_B.PROJ_DEV_VARIABLE_COST,

ACD_BUSINESS_DETAILS_B.PROJ_DEV_FIXED_COST,

ACD_BUSINESS_DETAILS_B.PROJ_DEV_LABOR_COST,

ACD_BUSINESS_DETAILS_B.PROJ_PROD_MATERIAL_COST,

ACD_BUSINESS_DETAILS_B.PROJ_PROD_VARIABLE_COST,

ACD_BUSINESS_DETAILS_B.PROJ_PROD_FIXED_COST,

ACD_BUSINESS_DETAILS_B.PROJ_PROD_LABOR_COST,

ACD_BUSINESS_DETAILS_B.PROJ_DEV_COST,

ACD_BUSINESS_DETAILS_B.PROJ_PROD_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_MATERIAL_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_VARIABLE_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_FIXED_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_DEV_LABOR_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_MATERIAL_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_VARIABLE_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_FIXED_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_PROD_LABOR_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_DEVELOPMENT_COST,

ACD_BUSINESS_DETAILS_B.ACTUAL_PRODUCTION_COST,

ACD_BUSINESS_DETAILS_B.PROB_OF_COMMERCIAL_SUCCESS,

ACD_BUSINESS_DETAILS_B.PROB_OF_TECHNICAL_SUCCESS,

ACD_BUSINESS_DETAILS_B.RESOURCE_VALUE_INDEX,

ACD_BUSINESS_DETAILS_B.COST_VALUE_INDEX,

ACD_BUSINESS_DETAILS_B.ACTUAL_COST,

ACD_BUSINESS_DETAILS_B.YEAR_2_REVENUE,

ACD_BUSINESS_DETAILS_B.YEAR_3_REVENUE,

ACD_BUSINESS_DETAILS_B.YEAR_5_REVENUE,

ACD_BUSINESS_DETAILS_B.RPI,

ACD_BUSINESS_DETAILS_B.CPI,

ACD_BUSINESS_DETAILS_B.PAYBACK_PERIOD,

ACD_BUSINESS_DETAILS_B.MARKET_GROWTH_PERCENT,

ACD_BUSINESS_DETAILS_B.MARKET_SHARE_PERCENT,

ACD_BUSINESS_DETAILS_B.PRODUCT_CATEGORIZATION,

ACD_BUSINESS_DETAILS_B.ALIGNMENT,

ACD_BUSINESS_DETAILS_B.IMPACT,

ACD_BUSINESS_DETAILS_B.COMPETITIVE_ADVANTAGE,

ACD_BUSINESS_DETAILS_B.SUPPLY_CHAIN_FIT,

ACD_BUSINESS_DETAILS_B.RND_KNOW_HOW,

ACD_BUSINESS_DETAILS_B.BUSINESS_UNIT_STRENGTH,

ACD_BUSINESS_DETAILS_B.MARKET_ATTRACTIVENESS,

ACD_BUSINESS_DETAILS_B.PROJECTED_MARGIN,

ACD_BUSINESS_DETAILS_B.ACTUAL_MARGIN,

ACD_BUSINESS_DETAILS_B.CREATED_BY CREATED_BY,

ACD_BUSINESS_DETAILS_B.CREATION_DATE CREATION_DATE,

ACD_BUSINESS_DETAILS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ACD_BUSINESS_DETAILS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ACD_BUSINESS_DETAILS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ACD_BUSINESS_DETAILS_B.MARKET_STRATEGY MARKET_STRATEGY

FROM

ACD_BUSINESS_DETAILS_B,

ACD_BUSINESS_DETAILS_TL

WHERE

ACD_BUSINESS_DETAILS_B.BUSINESS_DETAIL_ID = ACD_BUSINESS_DETAILS_TL.BUSINESS_DETAIL_ID AND ACD_BUSINESS_DETAILS_TL.LANGUAGE = USERENV('LANG')