[Home] [Help] [Dependency Information]
Object Name: | PON_SCORING_TEAMS |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_SCORING_TEAMS |
Subobject Name: | |
Status: | VALID |
PON_SCORING_TEAMS stores information about scoring teams that may be created optionally for a negotiation.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_SCORING_TEAMS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TEAM_ID |
PON_SCORING_TEAMS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AUCTION_HEADER_ID
TEAM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | Yes | Identifier of the negotiation to which this team belongs | |
TEAM_ID | NUMBER | Yes | System generated unique identifier for this team | |
TEAM_NAME | VARCHAR2 | (80) | User entered Team Name | |
PRICE_VISIBLE_FLAG | VARCHAR2 | (1) | Yes | If the pricing information on response documents should be available to the team when evaluating responses. If not set to 'Y' member of this team will not be able to view certain pages that display pricing information. |
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 | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
ORIG_TEAM_ID | NUMBER | Original Team ID used when copying negotiations/amendments/new rounds | ||
INSTRUCTION_TEXT | VARCHAR2 | (4000) | Scoring instructions for the Team members |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, TEAM_ID
, TEAM_NAME
, PRICE_VISIBLE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORIG_TEAM_ID
, INSTRUCTION_TEXT
FROM PON.PON_SCORING_TEAMS;
PON.PON_SCORING_TEAMS does not reference any database object
PON.PON_SCORING_TEAMS is referenced by following:
|
|
|