PO_CONFIG_COMPONENTS
PO_CONFIG_COMPONENTS stores current information about components (options and models) associated with configurable line items. Only documents associated with a Configure to Order Style are allowed to have configurable to order lines in their component details are stored in this table.
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PO_CONFIG_COMPONENTS_PK |
PO_CONFIG_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PO_CONFIG_COMPONENT_ID | NUMBER | 18 | Yes | Unique identifier of Configurable Option Component. | |
| PARENT_PO_CONFIG_COMPONENT_ID | NUMBER | 18 | Corresponds to the parent component line. If the parent is the base model, this field will be null. | ||
| OBJECT_HEADER_ID | NUMBER | 18 | Yes | Object header unique identifier. | |
| OBJECT_LINE_ID | NUMBER | 18 | Yes | Object line unique identifier. | |
| OBJECT_TYPE_CODE | VARCHAR2 | 25 | Yes | Type of the object. Possible object_type_codes are PO and REQ. | |
| COMPONENT_LINE_NUMBER | NUMBER | Configuration Component Line display value. | |||
| ITEM_ID | NUMBER | 18 | The buying organization's identification number or code for the component used in the configuration. | ||
| ITEM_REVISION | VARCHAR2 | 18 | Identifier that indicates the version of the component referenced in the configuration details. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Text describing the component used in the configuration. | ||
| ITEM_TYPE | VARCHAR2 | 30 | Used to indicate whether item is a configured product, an option class, or an option/standard item. | ||
| SUPPLIER_ITEM_NUMBER | VARCHAR2 | 300 | The supplier's identification number or code for the component. | ||
| BASE_MODEL_ID | NUMBER | 18 | The buying organization's identification number or code for the model on which the unique submodel is built. | ||
| COMPONENT_QUANTITY | NUMBER | Number of units needed to complete a single configuration. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | UOM of the component | |
| UNIT_PRICE | NUMBER | Price of the component | |||
| FROM_HEADER_ID | NUMBER | 18 | The purchase agreement against which this configuration component is released. | ||
| FROM_LINE_ID | NUMBER | 18 | The purchase agreement line against which this configuration component is released. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to 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. | ||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_CONFIG_COMPONENTS_N1 | Non Unique | Default | OBJECT_TYPE_CODE, OBJECT_LINE_ID |
| PO_CONFIG_COMPONENTS_N2 | Non Unique | Default | OBJECT_TYPE_CODE, OBJECT_HEADER_ID |
| PO_CONFIG_COMPONENTS_U1 | Unique | Default | PO_CONFIG_COMPONENT_ID |