PON_BID_REQUIREMENTS

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
BID_NUMBER REQUIREMENT_ID AUCTION_HEADER_ID OBJECT_VERSION_NUMBER SECTION_ID SCORE WEIGHTED_SCORE INTERNAL_NOTE COMMENTS OLD_COMMENTS CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN SEQUENCE_NUMBER HAS_BID_FLAG INTERFACE_LINE_ID WORKSHEET_NAME WORKSHEET_SEQUENCE_NUMBER

Name

BID_NUMBER

REQUIREMENT_ID

AUCTION_HEADER_ID

OBJECT_VERSION_NUMBER

SECTION_ID

SCORE

WEIGHTED_SCORE

INTERNAL_NOTE

COMMENTS

OLD_COMMENTS

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

SEQUENCE_NUMBER

HAS_BID_FLAG

INTERFACE_LINE_ID

WORKSHEET_NAME

WORKSHEET_SEQUENCE_NUMBER

Query

SQL_Statement
SELECT pbr.BID_NUMBER BID_NUMBER, pbr.REQUIREMENT_ID REQUIREMENT_ID, pbr.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbr.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbr.SECTION_ID SECTION_ID, pbr.SCORE SCORE, pbr.WEIGHTED_SCORE WEIGHTED_SCORE, pbr.INTERNAL_NOTE INTERNAL_NOTE, pbr.COMMENTS COMMENTS, pbr.OLD_COMMENTS OLD_COMMENTS, pbr.CREATION_DATE CREATION_DATE, pbr.CREATED_BY CREATED_BY, pbr.LAST_UPDATE_DATE LAST_UPDATE_DATE, pbr.LAST_UPDATED_BY LAST_UPDATED_BY, pbr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbr.SEQUENCE_NUMBER SEQUENCE_NUMBER, pbr.HAS_BID_FLAG HAS_BID_FLAG, pbr.INTERFACE_LINE_ID INTERFACE_LINE_ID, pbr.WORKSHEET_NAME WORKSHEET_NAME, pbr.WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER FROM PON_BID_REQUIREMENTS pbr, PON_REQUIREMENT_SECTIONS prs, PON_BID_HEADERS pbh, PON_AUCTION_HEADERS_ALL pah WHERE 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

pbr.BID_NUMBER BID_NUMBER,

pbr.REQUIREMENT_ID REQUIREMENT_ID,

pbr.AUCTION_HEADER_ID AUCTION_HEADER_ID,

pbr.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pbr.SECTION_ID SECTION_ID,

pbr.SCORE SCORE,

pbr.WEIGHTED_SCORE WEIGHTED_SCORE,

pbr.INTERNAL_NOTE INTERNAL_NOTE,

pbr.COMMENTS COMMENTS,

pbr.OLD_COMMENTS OLD_COMMENTS,

pbr.CREATION_DATE CREATION_DATE,

pbr.CREATED_BY CREATED_BY,

pbr.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pbr.LAST_UPDATED_BY LAST_UPDATED_BY,

pbr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pbr.SEQUENCE_NUMBER SEQUENCE_NUMBER,

pbr.HAS_BID_FLAG HAS_BID_FLAG,

pbr.INTERFACE_LINE_ID INTERFACE_LINE_ID,

pbr.WORKSHEET_NAME WORKSHEET_NAME,

pbr.WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER

FROM

PON_BID_REQUIREMENTS pbr,

PON_REQUIREMENT_SECTIONS prs,

PON_BID_HEADERS pbh,

PON_AUCTION_HEADERS_ALL pah

WHERE

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'))