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

TABLE: PON.PON_ATTRIBUTES_INTERFACE

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


PON_ATTRIBUTES_INTERFACE is used during BPA renegotiation. This table stores base and catalog descriptors in addition to the sourcing attributes. IP_CATEGORY_ID is 0 for base descriptors.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_ATTRIBUTES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_AUCTION_HEADER_ID
ColumnINTERFACE_LINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INTERFACE_AUCTION_HEADER_ID NUMBER
Yes Auction Header Id.
INTERFACE_LINE_NUMBER NUMBER
Yes Auction Line Number.
INTERFACE_SEQUENCE_NUMBER NUMBER

Attribute sequence number.
ATTRIBUTE_NAME VARCHAR2 (4000) Yes Attribute name.
DATATYPE VARCHAR2 (3) Yes Attribute datatype.
VALUE VARCHAR2 (2000)
Default value.
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 INTERFACE_AUCTION_HEADER_ID
,      INTERFACE_LINE_NUMBER
,      INTERFACE_SEQUENCE_NUMBER
,      ATTRIBUTE_NAME
,      DATATYPE
,      VALUE
,      IP_CATEGORY_ID
,      IP_DESCRIPTOR_ID
FROM PON.PON_ATTRIBUTES_INTERFACE;

Dependencies

[top of page]

PON.PON_ATTRIBUTES_INTERFACE does not reference any database object

PON.PON_ATTRIBUTES_INTERFACE is referenced by following:

SchemaAPPS
SynonymPON_ATTRIBUTES_INTERFACE