PON_NEG_TERMS_ACCEPTANCE

PON_NEG_TERMS_ACCEPTANCE table stores the acceptance of terms by the supplier contacts for a given negotiation. A row is created for each supplier contact who has either accepted/rejected the terms for the negotiation.

Details

• Schema: FUSION

• Object owner: PON

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PON_NEG_TERMS_ACCEPTANCE_PK	ACC_TERMS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACC_TERMS_ID	NUMBER		18	Yes	Primary key of the table
COMMENTS	VARCHAR2	4000			Stores comments provided by user while acccepting/declining terms before viewing negotiation
AUCTION_HEADER_ID	NUMBER		18	Yes	Foreign key reference from PON_AUCTION_HEADERS_ALL table
TRADING_PARTNER_ID	NUMBER		18	Yes	Supplier's company Id
VENDOR_SITE_ID	NUMBER		18	Yes	VENDOR_SITE_ID
TRADING_PARTNER_CONTACT_ID	NUMBER		18	Yes	Supplier User's ID
ACC_TERMS_FLAG	VARCHAR2	1			Flag to indicate whether the supplier contact has accepted or rejected the terms. Value is Y for acceptance and N for rejection
VERSION_NUM	NUMBER				Version number of the acceptance terms.
ACCEPTANCE_DATE	DATE				Date of acceptance of the supplier contact.
SURROG_BID_ACK_PERSON_ID	NUMBER		18		PERSON_ID of the buyer submitting the surrogate bid.
SURROG_BID_ACK_FLAG	VARCHAR2	1			Flag to indicate if the acknowledgement is surrogate.
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.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_NEG_TERMS_ACCEPTANCE	pon_auction_headers_all	AUCTION_HEADER_ID
PON_NEG_TERMS_ACCEPTANCE	hz_parties	TRADING_PARTNER_ID
PON_NEG_TERMS_ACCEPTANCE	hz_parties	TRADING_PARTNER_CONTACT_ID
PON_NEG_TERMS_ACCEPTANCE	per_persons	SURROG_BID_ACK_PERSON_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PON_NEG_TERMS_ACCEPTANCE_U1	Unique	Default	AUCTION_HEADER_ID, TRADING_PARTNER_ID, VENDOR_SITE_ID, TRADING_PARTNER_CONTACT_ID
PON_NEG_TERMS_ACCEPTANCE_U2	Unique	Default	ACC_TERMS_ID