eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PON.PON_CONTRACTS

Object Details

Object Name:	PON_CONTRACTS
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_CONTRACTS
Subobject Name:
Status:	VALID

PON_CONTRATCS stores contractual information such as business terms that a company requires its bidders and suppliers to accept before they can participate in a negotiation. Contracts are version controlled which means that a new version is created every time the contract is changed in the default language.
ENABLED_FLAG column indicates whether the contract is active. Note that a contract is enabled at the contract level, not per language.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_CONTRACTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRACT_ID VERSION_NUM ORG_ID
PON_CONTRACTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INTERNAL_NAME AUTHORING_PARTY_ID VERSION_NUM ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRACT_ID	NUMBER		Yes	Unique Identifier for contract
VERSION_NUM	NUMBER		Yes	Version Number
START_DATE	DATE			Contract Effective Start date
END_DATE	DATE			Contract Effective End date
AUTHORING_PARTY_ID	NUMBER		Yes	Unique Identifier for Trading Partner that owns the Contract
AUTHORING_PARTY_CONTACT_ID	NUMBER		Yes	Unique Identifier for contact person for Trading Partner that owns the Contract
INTERNAL_NAME	VARCHAR2	(80)	Yes	Contract Type Identifier. For auctions the internal name is AUC_TAC.
DESCRIPTION	VARCHAR2	(240)		Description
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
ATTRIBUTE1	VARCHAR2	(150)		Not currently used
ATTRIBUTE2	VARCHAR2	(150)		Not currently used
ATTRIBUTE3	VARCHAR2	(150)		Not currently used
ATTRIBUTE4	VARCHAR2	(150)		Not currently used
ATTRIBUTE5	VARCHAR2	(150)		Not currently used
ENABLED_FLAG	VARCHAR2	(1)		Flag Indicating if the contract is enabled
ORG_ID	NUMBER		Yes	Org Id
CONTRACT_STATUS	VARCHAR2	(240)		Contact Status

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTRACT_ID
,      VERSION_NUM
,      START_DATE
,      END_DATE
,      AUTHORING_PARTY_ID
,      AUTHORING_PARTY_CONTACT_ID
,      INTERNAL_NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ENABLED_FLAG
,      ORG_ID
,      CONTRACT_STATUS
FROM PON.PON_CONTRACTS;

Dependencies

[top of page]

PON.PON_CONTRACTS does not reference any database object

PON.PON_CONTRACTS is referenced by following:

PON: PON_CONTRACTS#