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_AUCTION_ATTRIBUTES

Object Details

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

PON_AUCTION_ATTRIBUTES stores item-specific attributes defined by the negotiation owner for auctions, RFQ, and RFIs. These attributes enable buyers to request information with more detail than is possible with the standard fields.
COPIED_FROM_CAT_FLAG indicates whether the attributes was copied from the category definition in the catalog.
If ATTRIBUTE_LIST_ID is populated, then the attribute belongs to a reusable attributes list. Otherwise, if AUCTION_HEADER_ID is populated, then the attribute belongs to a negotiation or a negotiation template. Only one of these two columns is populated for any single record.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_AUCTION_ATTRIBUTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID LINE_NUMBER SEQUENCE_NUMBER ATTRIBUTE_LIST_ID
PON_AUCTION_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_LIST_ID SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER			Auction Header Identifier
LINE_NUMBER	NUMBER			Auction Line Item
ATTRIBUTE_NAME	VARCHAR2	(4000)		Attribute Name
DESCRIPTION	VARCHAR2	(240)		Description
DATATYPE	VARCHAR2	(3)		Attribute value data type
MANDATORY_FLAG	VARCHAR2	(1)		Y or N flag to indicate that attribute is mandatory
VALUE	VARCHAR2	(4000)		Attribute auction value entered by the auctioneer
DISPLAY_PROMPT	VARCHAR2	(100)		Not currently used
HELP_TEXT	VARCHAR2	(2000)		Not currently used
DISPLAY_TARGET_FLAG	VARCHAR2	(1)		Y or N flag to indicate whether to display target value to the bidder
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
ATTRIBUTE_LIST_ID	NUMBER			Unique Identifier for attribute list
DISPLAY_ONLY_FLAG	VARCHAR2	(1)		Y or N flag to indicate display only
SEQUENCE_NUMBER	NUMBER			Sequence Number for attribute display order
COPIED_FROM_CAT_FLAG	VARCHAR2	(1)		Y or N flag to indicate copied from catalogue
WEIGHT	NUMBER			weight of the attribute
SCORING_TYPE	VARCHAR2	(25)		The scoring type. If this attribute is not scored, then this column has value "NONE". Or else if the attribute data type is NUMBER or DATE, then the value is "RANGE"; if the data type is TEXT, then the value is "LOV".
ATTR_LEVEL	VARCHAR2	(25)		Stores the level of the attribute - HEADER or LINE
ATTR_GROUP	VARCHAR2	(240)		Stores the group lookup code for this attribute
ATTR_MAX_SCORE	NUMBER			Maximum score for the header level attribute
INTERNAL_ATTR_FLAG	VARCHAR2	(1)		Denotes whether the header attribute is of type Internal
ATTR_GROUP_SEQ_NUMBER	NUMBER			User entered group sequence number
ATTR_DISP_SEQ_NUMBER	NUMBER			User entered attribute sequence number
MODIFIED_FLAG	VARCHAR2	(1)		Denotes whether the attribute has been modified in a new round or amendment
MODIFIED_DATE	DATE			Stores the date the attribute was modified
LAST_AMENDMENT_UPDATE	NUMBER			Holds the amendment number the attribute was last modified.
REQUEST_ID	NUMBER			Identifier of the concurrent program that last processed the row.
PROGRAM_APPLICATION_ID	NUMBER			Identifier of the owning application for the concurrent program that last updated this row.
PROGRAM_ID	NUMBER			Identifer of the concurrent program that last updated this row
PROGRAM_UPDATE_DATE	DATE			Date when this row was last updated by a concurrent program
KNOCKOUT_SCORE	NUMBER			Stores the Knockout score for the attribute.
SECTION_NAME	VARCHAR2	(240)		Stores the section name / group description
SCORING_METHOD	VARCHAR2	(30)		Stores the scoring method for the header attribute. Can have values 'AUTOMATIC', 'MANUAL' or 'NONE'
IP_CATEGORY_ID	NUMBER			IP Category ID.
IP_DESCRIPTOR_ID	NUMBER			iP descriptor ID.

Query Text

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


SELECT AUCTION_HEADER_ID
,      LINE_NUMBER
,      ATTRIBUTE_NAME
,      DESCRIPTION
,      DATATYPE
,      MANDATORY_FLAG
,      VALUE
,      DISPLAY_PROMPT
,      HELP_TEXT
,      DISPLAY_TARGET_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_LIST_ID
,      DISPLAY_ONLY_FLAG
,      SEQUENCE_NUMBER
,      COPIED_FROM_CAT_FLAG
,      WEIGHT
,      SCORING_TYPE
,      ATTR_LEVEL
,      ATTR_GROUP
,      ATTR_MAX_SCORE
,      INTERNAL_ATTR_FLAG
,      ATTR_GROUP_SEQ_NUMBER
,      ATTR_DISP_SEQ_NUMBER
,      MODIFIED_FLAG
,      MODIFIED_DATE
,      LAST_AMENDMENT_UPDATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      KNOCKOUT_SCORE
,      SECTION_NAME
,      SCORING_METHOD
,      IP_CATEGORY_ID
,      IP_DESCRIPTOR_ID
FROM PON.PON_AUCTION_ATTRIBUTES;

Dependencies

[top of page]

PON.PON_AUCTION_ATTRIBUTES does not reference any database object

PON.PON_AUCTION_ATTRIBUTES is referenced by following:

PON: PON_AUCTION_ATTRIBUTES#