ACN_REQUIREMENT_LINE_ITEM

Thsi table contains all line items (and their attributes) that belong to each version of the requirement object. The parent and child relationship of the line items is also captured here.

Details

  • Schema: FUSION

  • Object owner: ACN

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ACN_REQUIREMENT_LINE_ITEM_PK

REQUIREMENT_LINE_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments
REQUIREMENT_LINE_ITEM_ID NUMBER 18 Yes This is the primary key of the table
CURRENCY_CODE VARCHAR2 15 Column containing the Currency Code
CORP_CURRENCY_CODE VARCHAR2 15 Column with the Corporate Currency Code
CURCY_CONV_RATE_TYPE VARCHAR2 30 Type of the Currency Conversion Rate
OBJECT_ID NUMBER 18 This is the requirement version id of the associated req spec
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.
BASE_LINE_ITEM_ID NUMBER 18 Base line item id from the line item id when it is originallly created
NAME VARCHAR2 400 Yes This is the name of the requirement line item
REQUIREMENT_VERSION_ID NUMBER 18 Yes This is the (root) requirement version id
PARENT_LINE_ITEM_ID NUMBER 18 Line item ID of the direct parent. Null for the first level child.
SECTION_CODE VARCHAR2 400 This is the section code used to sort the line item table.
SECTION_NUMBER VARCHAR2 400 This is the section number used to indicate the section of the requirement line item ??? for flat table display
SCOPE VARCHAR2 30 This is the scope of the requirement line item. Lookup Type: ACN_REQUIREMENT_SCOPE. Possible values might be: In Scope/Out of Scope list, or Yes/No list
PRIORITY VARCHAR2 30 This is the priority of the requirement line item. Lookup Type: CAN_REQUIREMENT_PRIORITY Lookup Code: MUST HAVE, SHOULD HAVE, NICE TO HAVE
FULFILLED VARCHAR2 30 This is the fulfillment of the requirement line item.
ESTIMATES NUMBER 18 This is the estimates of the requirement line item. Its unit is defined by customer (such as in days)
CONTENT CLOB a rich text field of the requirement line item
DESCRIPTION VARCHAR2 1000 A description field for requirement line item.
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.
EXTN_ATTRIBUTE_CLOB001 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB002 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB003 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB004 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB005 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB006 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB007 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB008 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB009 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB010 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB011 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB012 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB013 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB014 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB015 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB016 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB017 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB018 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB019 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB020 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB021 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB022 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB023 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB024 CLOB Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CLOB025 CLOB Runtime Extensibility: Column reserved for custom extension attributes.

Foreign Keys

Table Foreign Table Foreign Key Column
ACN_REQUIREMENT_LINE_ITEM acn_req_version_b REQUIREMENT_VERSION_ID
ACN_REQUIREMENT_LINE_ITEM acn_requirement_line_item PARENT_LINE_ITEM_ID
ACN_REQUIREMENT_LINE_ITEM acn_req_version_b OBJECT_ID
acn_req_comment acn_requirement_line_item ID
acn_requirement_line_item acn_requirement_line_item PARENT_LINE_ITEM_ID

Indexes

Index Uniqueness Tablespace Columns
ACN_REQUIREMENT_LINE_ITEM_N1 Non Unique Default REQUIREMENT_VERSION_ID
ACN_REQUIREMENT_LINE_ITEM_N10 Non Unique Default BASE_LINE_ITEM_ID
ACN_REQUIREMENT_LINE_ITEM_N2 Non Unique Default EXTN_ATTRIBUTE_NUMBER001
ACN_REQUIREMENT_LINE_ITEM_N3 Non Unique Default EXTN_ATTRIBUTE_NUMBER002
ACN_REQUIREMENT_LINE_ITEM_N4 Non Unique Default EXTN_ATTRIBUTE_NUMBER003
ACN_REQUIREMENT_LINE_ITEM_N5 Non Unique Default EXTN_ATTRIBUTE_CHAR001
ACN_REQUIREMENT_LINE_ITEM_N6 Non Unique Default EXTN_ATTRIBUTE_CHAR002
ACN_REQUIREMENT_LINE_ITEM_N7 Non Unique Default OBJECT_ID
ACN_REQUIREMENT_LINE_ITEM_N8 Non Unique Default UPPER("NAME"), OBJECT_VERSION_NUMBER
ACN_REQUIREMENT_LINE_ITEM_N9 Non Unique Default PARENT_LINE_ITEM_ID
ACN_REQUIREMENT_LINE_ITEM_U1 Unique Default REQUIREMENT_LINE_ITEM_ID