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

TABLE: PON.PON_AUC_ATTRIBUTES_INTERFACE

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


PON_AUC_ATTRIBUTES_INTERFACE temporarily stores negotiation attribute information that the negotiation owner is uploading from a spreadsheet. Once the information is uploaded, the interface is processed and the errors are reported in PON_INTERFACE_ERRORS.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUC_ATTRIBUTES_INT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnINTERFACE_LINE_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER
Yes Batch Id
INTERFACE_LINE_ID NUMBER

Inteface Line Id
AUCTION_HEADER_ID NUMBER

Auction Header Id
AUCTION_LINE_NUMBER NUMBER

Auction Line Number
SEQUENCE_NUMBER NUMBER

Sequence Number
ATTRIBUTE_NAME VARCHAR2 (4000)
Attribute Name
DATATYPE VARCHAR2 (3)
Data Type
RESPONSE_TYPE_NAME VARCHAR2 (80)
Response Type Name
RESPONSE_TYPE VARCHAR2 (30)
Response Type
MANDATORY_FLAG VARCHAR2 (1)
Mandatory Flag
DISPLAY_ONLY_FLAG VARCHAR2 (1)
Display Only Flag
DISPLAY_TARGET_FLAG VARCHAR2 (1)
Display Target Flag
VALUE VARCHAR2 (4000)
Attribute Value
GROUP_CODE VARCHAR2 (30)
Attribute Group lookup code
GROUP_NAME VARCHAR2 (240)
Attribute Group Name
SCORING_TYPE VARCHAR2 (25)
Scoring Type
WEIGHT NUMBER

Stores the weight for Header attributes, otherwise null.
ATTR_MAX_SCORE NUMBER

Stores the maximum score for Header attributes, otherwise null.
INTERNAL_ATTR_FLAG VARCHAR2 (1)
Stores whether the header attribute is of type internal.
ATTR_GROUP_SEQ_NUMBER NUMBER

Attribute group sequence number
ATTR_DISP_SEQ_NUMBER NUMBER

Attribute display sequence number
SUB_LINE_SEQUENCE_NUMBER NUMBER

Sub line sequence number of lines being updated/inserted.
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 BATCH_ID
,      INTERFACE_LINE_ID
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      SEQUENCE_NUMBER
,      ATTRIBUTE_NAME
,      DATATYPE
,      RESPONSE_TYPE_NAME
,      RESPONSE_TYPE
,      MANDATORY_FLAG
,      DISPLAY_ONLY_FLAG
,      DISPLAY_TARGET_FLAG
,      VALUE
,      GROUP_CODE
,      GROUP_NAME
,      SCORING_TYPE
,      WEIGHT
,      ATTR_MAX_SCORE
,      INTERNAL_ATTR_FLAG
,      ATTR_GROUP_SEQ_NUMBER
,      ATTR_DISP_SEQ_NUMBER
,      SUB_LINE_SEQUENCE_NUMBER
,      IP_CATEGORY_ID
,      IP_DESCRIPTOR_ID
FROM PON.PON_AUC_ATTRIBUTES_INTERFACE;

Dependencies

[top of page]

PON.PON_AUC_ATTRIBUTES_INTERFACE does not reference any database object

PON.PON_AUC_ATTRIBUTES_INTERFACE is referenced by following:

SchemaAPPS
SynonymPON_AUC_ATTRIBUTES_INTERFACE