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

TABLE: PON.PON_FPJ_DELETED_ATTRIBUTES

Object Details
Object Name: PON_FPJ_DELETED_ATTRIBUTES
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_FPJ_DELETED_ATTRIBUTES
Subobject Name:
Status: VALID


This table is used to store data from the attributes table that was deleted as part of the Minimun release upgrade


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ENTITY_NAME VARCHAR2 (30)
Column distinguishes between pon_auction_attributes and pon_bid_attribute_values
AUCTION_HEADER_ID NUMBER

Foreign key to pon_auction_headers_all table
LINE_NUMBER NUMBER

FK to pon_auction_item_prices_all table
BID_NUMBER NUMBER

FK to pon_bid_headers table
NEG_TARGET_VALUE NUMBER

Stores the Negotiation target value
RESPONSE_VALUE NUMBER

Stores the bid response value for each line
Query Text

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


SELECT ENTITY_NAME
,      AUCTION_HEADER_ID
,      LINE_NUMBER
,      BID_NUMBER
,      NEG_TARGET_VALUE
,      RESPONSE_VALUE
FROM PON.PON_FPJ_DELETED_ATTRIBUTES;

Dependencies

[top of page]

PON.PON_FPJ_DELETED_ATTRIBUTES does not reference any database object

PON.PON_FPJ_DELETED_ATTRIBUTES is referenced by following:

SchemaPON
ViewPON_FPJ_DELETED_ATTRIBUTES#