PON_BID_ATTRIBUTE_VALUES

PON_BID_ATTRIBUTE_VALUES stores trading partners' responses to item attributes defined by the negotiation owner.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PON_BID_ATTRIBUTE_VALUES_PK	BID_NUMBER, LINE_NUMBER, SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
AUCTION_HEADER_ID	NUMBER		18	Yes	Auction Header Identifier
BID_NUMBER	NUMBER		18	Yes	Bid Number
LINE_NUMBER	NUMBER			Yes	Bid Line item
ATTRIBUTE_NAME	VARCHAR2	4000		Yes	Attribute name
DATATYPE	VARCHAR2	3		Yes	Attribute value data type
TEXT_VALUE	VARCHAR2	4000			Response value for a Text/URL requirement/value.
NUMBER_VALUE	NUMBER				Response value for a Number requirement/value.
DATE_VALUE	DATE				Response value for a Date requirement/value.
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.
SCORE	NUMBER				raw score of the bid attribute
SEQUENCE_NUMBER	NUMBER			Yes	sequence number for the auction attribute
ATTR_LEVEL	VARCHAR2	25			Stores the attribute level - HEADER or LINE
WEIGHTED_SCORE	NUMBER				Stores the calculated weighted score for the bid attribute value
ATTR_GROUP_SEQ_NUMBER	NUMBER				Group sequence number	Obsolete
ATTR_DISP_SEQ_NUMBER	NUMBER				Sequence number	Obsolete
INTERNAL_NOTE	VARCHAR2	4000			User entered scoring rationale
TEXT_OLD_VALUE	VARCHAR2	4000			Old response value for a Text/URL requirement/attribute.
NUMBER_OLD_VALUE	NUMBER				Old response value for a Number requirement/attribute.
DATE_OLD_VALUE	DATE				Old response value for a Date requirement/attribute.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APPLICATION_ID	NUMBER				Identifer of the owning application for the concurrent program that last updated this row.
PROGRAM_ID	NUMBER				Identifier of the concurrent program that last updated this row.
PROGRAM_UPDATE_DATE	DATE				Date when this row was last updated by a concurrent program.
PROGRAM_NAME	VARCHAR2	30			Identifies the concurrent program
PROGRAM_APP_NAME	VARCHAR2	50			Identifies the application name spawning the concurrent request.
BATCH_ID	NUMBER				Batch Id
INTERFACE_LINE_ID	NUMBER				Interface Line Id
WORKSHEET_NAME	VARCHAR2	80			Worksheet name
WORKSHEET_SEQUENCE_NUMBER	NUMBER				Sequence number for worksheet
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.
AUCTION_LINE_NUMBER	NUMBER			Yes	Line number of the Negotiation line. For Alternate lines, this will store the Negotiation Line number for which the alternate is created.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_BID_ATTRIBUTE_VALUES	pon_auction_headers_all	AUCTION_HEADER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PON_BID_ATTRIBUTE_VALUES_N1	Non Unique	Default	AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER
PON_BID_ATTRIBUTE_VALUES_U1	Unique	Default	BID_NUMBER, LINE_NUMBER, SEQUENCE_NUMBER