[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PON.PON_CONTRACTS does not reference any database object
PON.PON_CONTRACTS is referenced by following:
|
|
|