PON_BID_REQUIREMENT_VALUES

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
BID_NUMBER REQUIREMENT_VALUE_ID REQUIREMENT_ID AUCTION_HEADER_ID OBJECT_VERSION_NUMBER TEXT_VALUE DATE_VALUE NUMBER_VALUE SCORE_ID OLD_TEXT_VALUE OLD_NUMBER_VALUE OLD_DATE_VALUE OLD_IS_SELECTED_FLAG IS_SELECTED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN DATETIME_VALUE OLD_DATETIME_VALUE

Name

BID_NUMBER

REQUIREMENT_VALUE_ID

REQUIREMENT_ID

AUCTION_HEADER_ID

OBJECT_VERSION_NUMBER

TEXT_VALUE

DATE_VALUE

NUMBER_VALUE

SCORE_ID

OLD_TEXT_VALUE

OLD_NUMBER_VALUE

OLD_DATE_VALUE

OLD_IS_SELECTED_FLAG

IS_SELECTED_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

DATETIME_VALUE

OLD_DATETIME_VALUE

Query

SQL_Statement
SELECT pbrv.BID_NUMBER BID_NUMBER, pbrv.REQUIREMENT_VALUE_ID REQUIREMENT_VALUE_ID, pbrv.REQUIREMENT_ID REQUIREMENT_ID, pbrv.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbrv.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbrv.TEXT_VALUE TEXT_VALUE, pbrv.DATE_VALUE DATE_VALUE, pbrv.NUMBER_VALUE NUMBER_VALUE, pbrv.SCORE_ID SCORE_ID, pbrv.OLD_TEXT_VALUE OLD_TEXT_VALUE, pbrv.OLD_NUMBER_VALUE OLD_NUMBER_VALUE, pbrv.OLD_DATE_VALUE OLD_DATE_VALUE, pbrv.OLD_IS_SELECTED_FLAG OLD_IS_SELECTED_FLAG, pbrv.IS_SELECTED_FLAG IS_SELECTED_FLAG, pbrv.CREATION_DATE CREATION_DATE, pbrv.CREATED_BY CREATED_BY, pbrv.LAST_UPDATE_DATE LAST_UPDATE_DATE, pbrv.LAST_UPDATED_BY LAST_UPDATED_BY, pbrv.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbrv.DATETIME_VALUE DATETIME_VALUE, pbrv.OLD_DATETIME_VALUE OLD_DATETIME_VALUE FROM PON_BID_REQUIREMENT_VALUES pbrv, PON_BID_REQUIREMENTS pbr, PON_BID_HEADERS pbh, PON_AUCTION_HEADERS_ALL pah, PON_REQUIREMENT_SECTIONS prs WHERE pbrv.REQUIREMENT_ID = pbr.REQUIREMENT_ID AND pbrv.BID_NUMBER = pbr.BID_NUMBER AND pbr.SECTION_ID = prs.SECTION_ID AND pbh.BID_NUMBER = pbr.BID_NUMBER AND pah.AUCTION_HEADER_ID = prs.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND pbh.TECHNICAL_SHORTLIST_FLAG = 'Y') OR (pah.TWO_PART_FLAG = 'Y' AND NVL(pah.TECHNICAL_LOCK_STATUS, 'UNLOCKED') != 'LOCKED' AND prs.TWO_PART_SECTION_TYPE = 'TECHNICAL'))

SQL_Statement

SELECT

pbrv.BID_NUMBER BID_NUMBER,

pbrv.REQUIREMENT_VALUE_ID REQUIREMENT_VALUE_ID,

pbrv.REQUIREMENT_ID REQUIREMENT_ID,

pbrv.AUCTION_HEADER_ID AUCTION_HEADER_ID,

pbrv.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pbrv.TEXT_VALUE TEXT_VALUE,

pbrv.DATE_VALUE DATE_VALUE,

pbrv.NUMBER_VALUE NUMBER_VALUE,

pbrv.SCORE_ID SCORE_ID,

pbrv.OLD_TEXT_VALUE OLD_TEXT_VALUE,

pbrv.OLD_NUMBER_VALUE OLD_NUMBER_VALUE,

pbrv.OLD_DATE_VALUE OLD_DATE_VALUE,

pbrv.OLD_IS_SELECTED_FLAG OLD_IS_SELECTED_FLAG,

pbrv.IS_SELECTED_FLAG IS_SELECTED_FLAG,

pbrv.CREATION_DATE CREATION_DATE,

pbrv.CREATED_BY CREATED_BY,

pbrv.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pbrv.LAST_UPDATED_BY LAST_UPDATED_BY,

pbrv.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pbrv.DATETIME_VALUE DATETIME_VALUE,

pbrv.OLD_DATETIME_VALUE OLD_DATETIME_VALUE

FROM

PON_BID_REQUIREMENT_VALUES pbrv,

PON_BID_REQUIREMENTS pbr,

PON_BID_HEADERS pbh,

PON_AUCTION_HEADERS_ALL pah,

PON_REQUIREMENT_SECTIONS prs

WHERE

pbrv.REQUIREMENT_ID = pbr.REQUIREMENT_ID AND pbrv.BID_NUMBER = pbr.BID_NUMBER AND pbr.SECTION_ID = prs.SECTION_ID AND pbh.BID_NUMBER = pbr.BID_NUMBER AND pah.AUCTION_HEADER_ID = prs.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND pbh.TECHNICAL_SHORTLIST_FLAG = 'Y') OR (pah.TWO_PART_FLAG = 'Y' AND NVL(pah.TECHNICAL_LOCK_STATUS, 'UNLOCKED') != 'LOCKED' AND prs.TWO_PART_SECTION_TYPE = 'TECHNICAL'))