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

VIEW: PON.PON_AUC_ATTRIBUTES_INTERFACE#

Object Details
Object Name: PON_AUC_ATTRIBUTES_INTERFACE#
Object Type: VIEW
Owner: PON
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER

INTERFACE_LINE_ID NUMBER

AUCTION_HEADER_ID NUMBER

AUCTION_LINE_NUMBER NUMBER

SEQUENCE_NUMBER NUMBER

ATTRIBUTE_NAME VARCHAR2 (4000)
DATATYPE VARCHAR2 (3)
RESPONSE_TYPE_NAME VARCHAR2 (80)
RESPONSE_TYPE VARCHAR2 (30)
MANDATORY_FLAG VARCHAR2 (1)
DISPLAY_ONLY_FLAG VARCHAR2 (1)
DISPLAY_TARGET_FLAG VARCHAR2 (1)
VALUE VARCHAR2 (4000)
GROUP_CODE VARCHAR2 (30)
GROUP_NAME VARCHAR2 (240)
SCORING_TYPE VARCHAR2 (25)
WEIGHT NUMBER

ATTR_MAX_SCORE NUMBER

INTERNAL_ATTR_FLAG VARCHAR2 (1)
ATTR_GROUP_SEQ_NUMBER NUMBER

ATTR_DISP_SEQ_NUMBER NUMBER

SUB_LINE_SEQUENCE_NUMBER NUMBER

IP_CATEGORY_ID NUMBER

IP_DESCRIPTOR_ID NUMBER

KNOCKOUT_SCORE NUMBER

ACTION VARCHAR2 (30)
SCORING_METHOD VARCHAR2 (30)
INTERFACE_HEADER_ID NUMBER

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
,      KNOCKOUT_SCORE
,      ACTION
,      SCORING_METHOD
,      INTERFACE_HEADER_ID
FROM PON.PON_AUC_ATTRIBUTES_INTERFACE#;

Dependencies

[top of page]

PON.PON_AUC_ATTRIBUTES_INTERFACE# references the following:

SchemaPON
TablePON_AUC_ATTRIBUTES_INTERFACE
PON.PON_AUC_ATTRIBUTES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymPON_AUC_ATTRIBUTES_INTERFACE