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

VIEW: PON.PON_BID_ATTRIBUTE_VALUES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUCTION_HEADER_ID NUMBER
Yes
AUCTION_LINE_NUMBER NUMBER
Yes
BID_NUMBER NUMBER
Yes
LINE_NUMBER NUMBER
Yes
ATTRIBUTE_NAME VARCHAR2 (4000) Yes
DATATYPE VARCHAR2 (3) Yes
VALUE VARCHAR2 (4000)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
SCORE NUMBER

SEQUENCE_NUMBER NUMBER

ATTR_LEVEL VARCHAR2 (25)
WEIGHTED_SCORE NUMBER

ATTR_GROUP_SEQ_NUMBER NUMBER

ATTR_DISP_SEQ_NUMBER NUMBER

INTERNAL_NOTE VARCHAR2 (240)
OLD_VALUE VARCHAR2 (4000)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

BATCH_ID NUMBER

INTERFACE_LINE_ID NUMBER

WORKSHEET_NAME VARCHAR2 (80)
WORKSHEET_SEQUENCE_NUMBER NUMBER

Query Text

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


SELECT AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      LINE_NUMBER
,      ATTRIBUTE_NAME
,      DATATYPE
,      VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SCORE
,      SEQUENCE_NUMBER
,      ATTR_LEVEL
,      WEIGHTED_SCORE
,      ATTR_GROUP_SEQ_NUMBER
,      ATTR_DISP_SEQ_NUMBER
,      INTERNAL_NOTE
,      OLD_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_ID
,      INTERFACE_LINE_ID
,      WORKSHEET_NAME
,      WORKSHEET_SEQUENCE_NUMBER
FROM PON.PON_BID_ATTRIBUTE_VALUES#;

Dependencies

[top of page]

PON.PON_BID_ATTRIBUTE_VALUES# references the following:

SchemaPON
TablePON_BID_ATTRIBUTE_VALUES
PON.PON_BID_ATTRIBUTE_VALUES# is referenced by following:

SchemaAPPS
SynonymPON_BID_ATTRIBUTE_VALUES