[Home] [Help] [Dependency Information]
Object Name: | PON_ATTRIBUTE_SCORES |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_ATTRIBUTE_SCORES |
Subobject Name: | |
Status: | VALID |
PON_ATTRIBUTE_SCORES stores the scoring criteria for a particular attribute in either an auction item or a reusable attribute list. The master table is PON_AUCTION_ATTRIBUTES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_ATTRIBUTE_SCORES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AUCTION_HEADER_ID
LINE_NUMBER ATTRIBUTE_SEQUENCE_NUMBER SEQUENCE_NUMBER ATTRIBUTE_LIST_ID |
PON_ATTRIBUTE_SCORES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ATTRIBUTE_LIST_ID
ATTRIBUTE_SEQUENCE_NUMBER SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | Auction number. PK to pon_auction_attributes | ||
LINE_NUMBER | NUMBER | Auction item number. PK to pon_auction_attributes | ||
ATTRIBUTE_SEQUENCE_NUMBER | NUMBER | Attribute Sequence Number. PK to pon_auction_attributes | ||
VALUE | VARCHAR2 | (240) | acceptable bid value for text attribute type | |
FROM_RANGE | VARCHAR2 | (50) | beginning of range for date and number attribute type | |
TO_RANGE | VARCHAR2 | (50) | end of range for date and number attribute type | |
SCORE | NUMBER | raw score for this range or acceptable value | ||
ATTRIBUTE_LIST_ID | NUMBER | FK to pon_auction_attributes if it is part of a resuable attribute list | ||
SEQUENCE_NUMBER | NUMBER | order of the scoring criteria, part of PK | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, LINE_NUMBER
, ATTRIBUTE_SEQUENCE_NUMBER
, VALUE
, FROM_RANGE
, TO_RANGE
, SCORE
, ATTRIBUTE_LIST_ID
, SEQUENCE_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM PON.PON_ATTRIBUTE_SCORES;
PON.PON_ATTRIBUTE_SCORES does not reference any database object
PON.PON_ATTRIBUTE_SCORES is referenced by following:
|
|
|