1. Tables and Views for Procurement
  2. PO_CONFIG_COMPONENTS_ARCHIVE

PO_CONFIG_COMPONENTS_ARCHIVE

PO_CONFIG_COMPONENTS_ARCHIVE stores past and 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. You can retrieve revisions of the purchase order line using this table. The latest archived revision will have TO_CO_SEQ set to '999999'. You need one row for each document configuration entry you archive. Each row contains the same information as the PO_CONFIG_COMPONENTS table. Oracle Purchasing uses this information to ensure you keep copies of your legal documents. Oracle Purchasing does not currently read or retrieve information in this table.

Details

  • Schema: FUSION

  • Object owner: PO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PO_CONFIG_COMPS_ARCHIVE_PK

PO_CONFIG_COMPONENT_ID, FROM_CO_SEQ

Columns

Name Datatype Length Precision Not-null Comments
PO_CONFIG_COMPONENT_ID NUMBER 18 Yes Unique identifier of Configurable Option Component.
ENTITY_CHANGE_TYPE_CODE VARCHAR2 1 Indicates if the row is new or changed.
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.
FROM_CO_SEQ NUMBER Yes FROM_CO_SEQ
TO_CO_SEQ NUMBER Yes TO_CO_SEQ
ENTITY_CO_DISPOSITION VARCHAR2 25 ENTITY_CO_DISPOSITION
REASON_FOR_CHANGE VARCHAR2 240 REASON_FOR_CHANGE
EXTERNAL_CHANGE_FLAG VARCHAR2 1 EXTERNAL_CHANGE_FLAG
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_COMPS_ARCHIVE_N1 Non Unique Default OBJECT_TYPE_CODE, OBJECT_LINE_ID
PO_CONFIG_COMPS_ARCHIVE_N2 Non Unique Default OBJECT_TYPE_CODE, OBJECT_HEADER_ID
PO_CONFIG_COMPS_ARCHIVE_U1 Unique Default PO_CONFIG_COMPONENT_ID, FROM_CO_SEQ