PON_AUCTION_ATTRIBUTES
PON_AUCTION_ATTRIBUTES stores item-specific attributes defined by the negotiation owner for auctions, RFQ, and RFIs. These attributes enable buyers to request information with more detail than is possible with the standard fields. COPIED_FROM_CAT_FLAG indicates whether the attributes was copied from the category definition in the catalog. If ATTRIBUTE_LIST_ID is populated, then the attribute belongs to a reusable attributes list. Otherwise, if AUCTION_HEADER_ID is populated, then the attribute belongs to a negotiation or a negotiation template. Only one of these two columns is populated for any single record.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PON_AUCTION_ATTRIBUTES_PK |
AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER, ATTRIBUTE_LIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header Identifier | |
| LINE_NUMBER | NUMBER | Yes | Auction Line Item | ||
| ATTRIBUTE_NAME | VARCHAR2 | 4000 | Attribute Name | ||
| DATATYPE | VARCHAR2 | 3 | Attribute value data type | ||
| DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Y or N flag to indicate whether to display target value to the bidder | ||
| RESPONSE_TYPE | VARCHAR2 | 30 | Response type of a requirement/attribute. Could be REQUIRED, DISPLAY_ONLY and INTERNAL. | ||
| TEXT_VALUE | VARCHAR2 | 4000 | Target value for a Text/Url type requirement/attribute. | ||
| NUMBER_VALUE | NUMBER | Target value for a number type requirement/attribute. | |||
| DATE_VALUE | DATE | Target value for a date type requirement/attribute. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| ATTRIBUTE_LIST_ID | NUMBER | 18 | Yes | Unique Identifier for attribute list | |
| SEQUENCE_NUMBER | NUMBER | Yes | Sequence Number for attribute display order | ||
| WEIGHT | NUMBER | weight of the attribute | |||
| SCORING_TYPE | VARCHAR2 | 25 | The scoring type. If this attribute is not scored, then this column has value "NONE". Or else if the attribute data type is NUMBER or DATE, then the value is "RANGE"; if the data type is TEXT, then the value is "LOV". | ||
| ATTR_LEVEL | VARCHAR2 | 25 | Stores the level of the attribute - HEADER or LINE | ||
| ATTR_MAX_SCORE | NUMBER | Maximum score for the header level attribute | |||
| ATTR_GROUP_SEQ_NUMBER | NUMBER | User entered group sequence number | |||
| ATTR_DISP_SEQ_NUMBER | NUMBER | User entered attribute sequence number | |||
| MODIFIED_FLAG | VARCHAR2 | 1 | Denotes whether the attribute has been modified in a new round or amendment | ||
| MODIFIED_DATE | DATE | Stores the date the attribute was modified | |||
| LAST_AMENDMENT_UPDATE | NUMBER | Holds the amendment number the attribute was last modified. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the program name | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the application name spawning the concurrent request. | ||
| KNOCKOUT_SCORE | NUMBER | Stores the Knockout score for the attribute. | |||
| SECTION_NAME | VARCHAR2 | 240 | Stores the section name / group description | ||
| SCORING_METHOD | VARCHAR2 | 30 | Stores the scoring method for the header attribute. Can have values 'AUTOMATIC', 'MANUAL' or 'NONE' | ||
| IP_CATEGORY_ID | NUMBER | IP Category ID. | |||
| IP_DESCRIPTOR_ID | NUMBER | iP descriptor 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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SECTION_ID | NUMBER | 18 | Yes | Acution attribute section id. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_AUCTION_ATTRIBUTES | pon_auction_sections | SECTION_ID |
| pon_attribute_scores | pon_auction_attributes | AUCTION_HEADER_ID, LINE_NUMBER, ATTRIBUTE_SEQUENCE_NUMBER, ATTRIBUTE_LIST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_AUCTION_ATTRIBUTES_N1 | Non Unique | Default | ATTRIBUTE_LIST_ID, SEQUENCE_NUMBER |
| PON_AUCTION_ATTRIBUTES_N2 | Non Unique | Default | ATTRIBUTE_LIST_ID, ATTRIBUTE_NAME |
| PON_AUCTION_ATTRIBUTES_N3 | Non Unique | Default | SECTION_ID |
| PON_AUCTION_ATTRIBUTES_U1 | Unique | Default | AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER, ATTRIBUTE_LIST_ID |