ACE_SELECTED_PRODUCTS
This table stores the product concepts added to portfolios and its scenarios.
Details
-
Schema: FUSION
-
Object owner: ACE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACE_SELECTED_PRODUCTS_PK |
SELECTED_PRODUCTS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SELECTED_PRODUCTS_ID | NUMBER | 18 | Yes | Primary Key which will be system generated Application Unique Id. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CONCEPT_MASTER_ID | NUMBER | 18 | Yes | ID of the product concept which is added to the scenario. | |
| PRODUCT_PROPOSAL_ID | NUMBER | 18 | Yes | ID of the cloned copy of the product concept which is added to the scenario. | |
| BUSINESS_OBJECT_ID | NUMBER | 18 | Yes | Primary Key of the business object to which this product concept is added . For eg. Portfolio ID or scenario ID. | |
| BUSINESS_OBJECT_TYPE | VARCHAR2 | 1 | Yes | Flag which indicates the type of the business object to which the product concept is added. ???P??? stands for Portfolio and ???S??? stands for Scenario. | |
| INCLUDED | VARCHAR2 | 1 | Yes | Flag which indicates the product object is selected for scenario or not. | |
| PRIORITY | NUMBER | Priority of the product concept within the scenario. | |||
| RANK | NUMBER | Ranking of the product concept within the scenario. | |||
| SCORE | NUMBER | Score of the product concept within the scenario. | |||
| NET_PRESENT_VALUE | NUMBER | Product Metric : Net Present Value | |||
| INTERNAL_RATE_OF_RETURN | NUMBER | Product Metric : Internal Rate of Return | |||
| RESOURCE_VALUE_INDEX | NUMBER | Product Metric : NPV / Total resources | |||
| COST_VALUE_INDEX | NUMBER | Product Metric : NPV / Total cost | |||
| YEAR_2_REVENUE | NUMBER | Product Metric : 2 year revenue | |||
| YEAR_3_REVENUE | NUMBER | Product Metric : 3 year revenue | |||
| YEAR_5_REVENUE | NUMBER | Product Metric : 5 year revenue | |||
| RPI | NUMBER | Product Metric : RESOURCES_PRODUCTIVITY_INDEX. ECV / Total resources | |||
| CPI | NUMBER | Product Metric : COST_PRODUCTIVITY_INDEX. ECV / Total cost | |||
| TRCC | NUMBER | Product Metric : TOTAL_RESOURCE_COST_CONSUMED. Monetary equivalent of resources consumed by all the products selected by user to be part of the scenario | |||
| ROI | NUMBER | Product Metric : Return On Investment. | |||
| PAYBACK_PERIOD | NUMBER | Product Metric : PAYBACK_PERIOD | |||
| PRODUCT_STRATEGIC_IMP | NUMBER | Product Metric : PRODUCT_STRATEGIC_IMPORTANCE. The values for this column will be maintained in FND_LOOKUPS under the ACE_PRODUCT_STRATEGIC_IMP lookup type. The values are 1...5. | |||
| MARKET_GROWTH_PERCENT | NUMBER | Product Metric : MARKET_GROWTH_PERCENT | |||
| MARKET_SHARE_PERCENT | NUMBER | Product Metric : MARKET_SHARE_PERCENT | |||
| MARKET_ATTRACTIVENESS | NUMBER | Product Metric : MARKET_ATTRACTIVENESS | |||
| PRODUCT_CATEGORIZATION | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_PRODUCT_CATEGORIZATIONS lookup type. The values are Question Mark, Star, Cash Cow, Dog | ||
| ALIGNMENT | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_ALIGNMENT lookup type. | ||
| IMPACT | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_IMPACT lookup type. | ||
| COMPETITIVE_ADVANTAGE | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_COMPETETIVE_ADVANTAGE lookup type. | ||
| SUPPLY_CHAIN_FIT | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_SUPPLY_CHAIN_FIT lookup type. | ||
| RND_KNOW_HOW | VARCHAR2 | 30 | Product Metric : The values for this column will be maintained in FND_LOOKUPS under the ACE_RND_KNOW_HOW lookup type. | ||
| BUSINESS_UNIT_STRENGTH | NUMBER | Product Metric : BUSINESS_UNIT_STRENGTH | |||
| EXPECTED_COMMERCIAL_VALUE | NUMBER | Proudct Metric:Expected Commercial Value | |||
| PROJECTED_COST | NUMBER | Product Metric : Projected Cost | |||
| ACTUAL_COST | NUMBER | Product Metric: Actual product costs. | |||
| ACTUAL_RESOURCES | NUMBER | Product Metric : Actual Resources | |||
| PROJECTED_RESOURCES | NUMBER | Product Metric : Projected Resources | |||
| ACTUAL_REVENUE | NUMBER | Product Metric : Actual Revenue | |||
| ACTUAL_MARGIN | NUMBER | Difference of Actual Revenue & Actual Cost | |||
| PROJECTED_REVENUE | NUMBER | Product Metric : Projected Revenue | |||
| PROJECTED_MARGIN | NUMBER | Difference of Projected Revenue & Projected Cost | |||
| RISK_SUBJECTIVE | VARCHAR2 | 30 | Product Metric : Risk Subjective | ||
| RISK_NUMBERIC | VARCHAR2 | 30 | Product Metric: Numeric representation of risk. | ||
| PRODUCT_STRATEGIC_FIT | VARCHAR2 | 30 | Product Metric : Product Strategic Fit | ||
| PROJ_DEV_MATERIAL_COST | NUMBER | Product Metric : Projected Development Material Cost | |||
| PROJ_DEV_VARIABLE_COST | NUMBER | Product Metric : Projected Development Variable Cost | |||
| PROJ_DEV_FIXED_COST | NUMBER | Product Metric : Projected Development Fixed Cost | |||
| PROJ_DEV_LABOR_COST | NUMBER | Product Metric : Projected Development Labor Cost | |||
| PROJ_PROD_MATERIAL_COST | NUMBER | Product Metric : Projected Production Material Cost | |||
| PROJ_PROD_VARIABLE_COST | NUMBER | Product Metric : Projected Production Variable Cost | |||
| PROJ_PROD_FIXED_COST | NUMBER | Product Metric : Projected Production Fixed Cost | |||
| PROJ_PROD_LABOR_COST | NUMBER | Product Metric : Projected Production Labor Cost | |||
| PROJ_DEV_COST | NUMBER | Product Metric : Projected Development Cost | |||
| PROJ_PROD_COST | NUMBER | Product Metric : Projected Production Cost | |||
| ACTUAL_DEV_MATERIAL_COST | NUMBER | Product Metric : Actual Development Material Cost | |||
| ACTUAL_DEV_VARIABLE_COST | NUMBER | Product Metric : Actual Development Variable Cost | |||
| ACTUAL_DEV_FIXED_COST | NUMBER | Product Metric : Actual Development Fixed Cost | |||
| ACTUAL_DEV_LABOR_COST | NUMBER | Product Metric : Actual Development Labor Cost | |||
| ACTUAL_PROD_MATERIAL_COST | NUMBER | Product Metric : Actual Production Material Cost | |||
| ACTUAL_PROD_VARIABLE_COST | NUMBER | Product Metric : Actual Production Variable Cost | |||
| ACTUAL_PROD_FIXED_COST | NUMBER | Product Metric : Actual Production Fixed Cost | |||
| ACTUAL_PROD_LABOR_COST | NUMBER | Product Metric : Actual Production Labor Cost | |||
| ACTUAL_DEVELOPMENT_COST | NUMBER | Product Metric : Actual Development Cost | |||
| ACTUAL_PRODUCTION_COST | NUMBER | Product Metric : Actual Production Cost | |||
| PROB_OF_COMMERCIAL_SUCCESS | NUMBER | Product Metric : Probability of Commercial Success | |||
| PROB_OF_TECHNICAL_SUCCESS | NUMBER | Product Metric : Probability of Technical Success | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR001 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR002 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR003 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR004 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR005 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR006 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR007 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR008 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR009 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR010 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR011 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR012 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR013 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR014 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR015 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR016 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR017 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR018 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR019 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR020 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR021 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR022 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR023 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR024 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR025 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR026 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR027 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR028 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR029 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR030 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR031 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR032 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR033 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR034 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR035 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR036 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR037 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR038 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR039 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR040 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR041 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR042 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP011 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP012 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR043 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR044 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR045 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR046 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR047 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR048 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR049 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR050 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR051 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR052 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR053 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR054 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR055 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR056 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP013 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP014 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP015 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR057 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR058 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR059 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR060 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR061 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR062 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR063 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR064 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR065 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR066 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR067 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR068 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR069 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR070 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP016 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP017 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP018 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR071 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR072 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR073 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR074 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR075 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR076 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR077 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR078 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR079 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR080 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR081 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR082 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR083 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR084 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_TIMESTAMP019 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP020 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CHAR085 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR086 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR087 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR088 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR089 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR090 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR091 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR092 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR093 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR094 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR095 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR096 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR097 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR098 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR099 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR100 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_NUMBER201 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER202 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER203 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER204 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER205 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ACE_SELECTED_PRODUCTS | acd_product_proposal | PRODUCT_PROPOSAL_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACE_SELECTED_PRODUCTS_N1 | Non Unique | Default | BUSINESS_OBJECT_TYPE |
| ACE_SELECTED_PRODUCTS_N2 | Non Unique | Default | INCLUDED |
| ACE_SELECTED_PRODUCTS_N3 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER001 |
| ACE_SELECTED_PRODUCTS_N4 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER002 |
| ACE_SELECTED_PRODUCTS_N5 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER003 |
| ACE_SELECTED_PRODUCTS_N6 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR001 |
| ACE_SELECTED_PRODUCTS_N7 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR002 |
| ACE_SELECTED_PRODUCTS_U1 | Unique | Default | SELECTED_PRODUCTS_ID |
| ACE_SELECTED_PRODUCTS_U2 | Unique | Default | CONCEPT_MASTER_ID, BUSINESS_OBJECT_ID |