PON_BID_ATTRIBUTE_VALUES

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
AUCTION_HEADER_ID BID_NUMBER LINE_NUMBER ATTRIBUTE_NAME DATATYPE TEXT_VALUE NUMBER_VALUE DATE_VALUE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY SCORE SEQUENCE_NUMBER ATTR_LEVEL WEIGHTED_SCORE INTERNAL_NOTE TEXT_OLD_VALUE NUMBER_OLD_VALUE DATE_OLD_VALUE REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE PROGRAM_NAME PROGRAM_APP_NAME BATCH_ID INTERFACE_LINE_ID WORKSHEET_NAME WORKSHEET_SEQUENCE_NUMBER OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN AUCTION_LINE_NUMBER

Name

AUCTION_HEADER_ID

BID_NUMBER

LINE_NUMBER

ATTRIBUTE_NAME

DATATYPE

TEXT_VALUE

NUMBER_VALUE

DATE_VALUE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

SCORE

SEQUENCE_NUMBER

ATTR_LEVEL

WEIGHTED_SCORE

INTERNAL_NOTE

TEXT_OLD_VALUE

NUMBER_OLD_VALUE

DATE_OLD_VALUE

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

PROGRAM_NAME

PROGRAM_APP_NAME

BATCH_ID

INTERFACE_LINE_ID

WORKSHEET_NAME

WORKSHEET_SEQUENCE_NUMBER

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

AUCTION_LINE_NUMBER

Query

SQL_Statement
SELECT pba.AUCTION_HEADER_ID AUCTION_HEADER_ID, pba.BID_NUMBER BID_NUMBER, pba.LINE_NUMBER LINE_NUMBER, pba.ATTRIBUTE_NAME ATTRIBUTE_NAME, pba.DATATYPE DATATYPE, NVL2(pba.TEXT_VALUE, 'Secure', NULL) TEXT_VALUE, pba.NUMBER_VALUE NUMBER_VALUE, pba.DATE_VALUE DATE_VALUE, pba.CREATION_DATE CREATION_DATE, pba.CREATED_BY CREATED_BY, pba.LAST_UPDATE_DATE LAST_UPDATE_DATE, pba.LAST_UPDATED_BY LAST_UPDATED_BY, pba.SCORE SCORE, pba.SEQUENCE_NUMBER SEQUENCE_NUMBER, pba.ATTR_LEVEL ATTR_LEVEL, pba.WEIGHTED_SCORE WEIGHTED_SCORE, NVL2(pba.INTERNAL_NOTE, 'Secure', NULL) INTERNAL_NOTE, pba.TEXT_OLD_VALUE TEXT_OLD_VALUE, pba.NUMBER_OLD_VALUE NUMBER_OLD_VALUE, pba.DATE_OLD_VALUE DATE_OLD_VALUE, pba.REQUEST_ID REQUEST_ID, pba.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, pba.PROGRAM_ID PROGRAM_ID, pba.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, pba.PROGRAM_NAME PROGRAM_NAME, pba.PROGRAM_APP_NAME PROGRAM_APP_NAME, pba.BATCH_ID BATCH_ID, pba.INTERFACE_LINE_ID INTERFACE_LINE_ID, pba.WORKSHEET_NAME WORKSHEET_NAME, pba.WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER, pba.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pba.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pba.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER FROM PON_BID_ATTRIBUTE_VALUES pba, PON_AUCTION_HEADERS_ALL pah, PON_BID_HEADERS pbh WHERE pba.BID_NUMBER = pbh.BID_NUMBER AND pba.LINE_NUMBER != -1 AND pah.AUCTION_HEADER_ID = pbh.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (NVL(pah.TWO_PART_FLAG, 'N') = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))

SQL_Statement

SELECT

pba.AUCTION_HEADER_ID AUCTION_HEADER_ID,

pba.BID_NUMBER BID_NUMBER,

pba.LINE_NUMBER LINE_NUMBER,

pba.ATTRIBUTE_NAME ATTRIBUTE_NAME,

pba.DATATYPE DATATYPE,

NVL2(pba.TEXT_VALUE, 'Secure', NULL) TEXT_VALUE,

pba.NUMBER_VALUE NUMBER_VALUE,

pba.DATE_VALUE DATE_VALUE,

pba.CREATION_DATE CREATION_DATE,

pba.CREATED_BY CREATED_BY,

pba.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pba.LAST_UPDATED_BY LAST_UPDATED_BY,

pba.SCORE SCORE,

pba.SEQUENCE_NUMBER SEQUENCE_NUMBER,

pba.ATTR_LEVEL ATTR_LEVEL,

pba.WEIGHTED_SCORE WEIGHTED_SCORE,

NVL2(pba.INTERNAL_NOTE, 'Secure', NULL) INTERNAL_NOTE,

pba.TEXT_OLD_VALUE TEXT_OLD_VALUE,

pba.NUMBER_OLD_VALUE NUMBER_OLD_VALUE,

pba.DATE_OLD_VALUE DATE_OLD_VALUE,

pba.REQUEST_ID REQUEST_ID,

pba.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID,

pba.PROGRAM_ID PROGRAM_ID,

pba.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE,

pba.PROGRAM_NAME PROGRAM_NAME,

pba.PROGRAM_APP_NAME PROGRAM_APP_NAME,

pba.BATCH_ID BATCH_ID,

pba.INTERFACE_LINE_ID INTERFACE_LINE_ID,

pba.WORKSHEET_NAME WORKSHEET_NAME,

pba.WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER,

pba.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pba.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pba.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER

FROM

PON_BID_ATTRIBUTE_VALUES pba,

PON_AUCTION_HEADERS_ALL pah,

PON_BID_HEADERS pbh

WHERE

pba.BID_NUMBER = pbh.BID_NUMBER AND pba.LINE_NUMBER != -1 AND pah.AUCTION_HEADER_ID = pbh.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (NVL(pah.TWO_PART_FLAG, 'N') = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))