PON_BID_PRICE_ELEMENTS

Details

Schema: FUSION
Object owner: PON
Object type: VIEW

Columns

Name
BID_NUMBER LINE_NUMBER PRICE_ELEMENT_TYPE_ID AUCTION_HEADER_ID PRICING_BASIS AUCTION_CURRENCY_VALUE BID_CURRENCY_VALUE SEQUENCE_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY PF_TYPE OLD_BID_CURRENCY_VALUE REQUEST_ID PROGRAM_UPDATE_DATE PROGRAM_NAME PROGRAM_APP_NAME BATCH_ID OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN INTERFACE_LINE_ID AUCTION_LINE_NUMBER

Name

BID_NUMBER

LINE_NUMBER

PRICE_ELEMENT_TYPE_ID

AUCTION_HEADER_ID

PRICING_BASIS

AUCTION_CURRENCY_VALUE

BID_CURRENCY_VALUE

SEQUENCE_NUMBER

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

PF_TYPE

OLD_BID_CURRENCY_VALUE

REQUEST_ID

PROGRAM_UPDATE_DATE

PROGRAM_NAME

PROGRAM_APP_NAME

BATCH_ID

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

INTERFACE_LINE_ID

AUCTION_LINE_NUMBER

Query

SQL_Statement
SELECT pbp.BID_NUMBER BID_NUMBER, pbp.LINE_NUMBER LINE_NUMBER, pbp.PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID, pbp.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbp.PRICING_BASIS PRICING_BASIS, pbp.AUCTION_CURRENCY_VALUE AUCTION_CURRENCY_VALUE, pbp.BID_CURRENCY_VALUE BID_CURRENCY_VALUE, pbp.SEQUENCE_NUMBER SEQUENCE_NUMBER, pbp.CREATION_DATE CREATION_DATE, pbp.CREATED_BY CREATED_BY, pbp.LAST_UPDATE_DATE LAST_UPDATE_DATE, pbp.LAST_UPDATED_BY LAST_UPDATED_BY, pbp.PF_TYPE PF_TYPE, pbp.OLD_BID_CURRENCY_VALUE OLD_BID_CURRENCY_VALUE, pbp.REQUEST_ID REQUEST_ID, pbp.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, pbp.PROGRAM_NAME PROGRAM_NAME, pbp.PROGRAM_APP_NAME PROGRAM_APP_NAME, pbp.BATCH_ID BATCH_ID, pbp.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbp.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbp.INTERFACE_LINE_ID INTERFACE_LINE_ID, pbp.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER FROM PON_BID_PRICE_ELEMENTS pbp, PON_AUCTION_HEADERS_ALL pah, PON_BID_HEADERS pbh WHERE pbp.BID_NUMBER = pbh.BID_NUMBER 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 (pah.TWO_PART_FLAG = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))

SQL_Statement

SELECT

pbp.BID_NUMBER BID_NUMBER,

pbp.LINE_NUMBER LINE_NUMBER,

pbp.PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID,

pbp.AUCTION_HEADER_ID AUCTION_HEADER_ID,

pbp.PRICING_BASIS PRICING_BASIS,

pbp.AUCTION_CURRENCY_VALUE AUCTION_CURRENCY_VALUE,

pbp.BID_CURRENCY_VALUE BID_CURRENCY_VALUE,

pbp.SEQUENCE_NUMBER SEQUENCE_NUMBER,

pbp.CREATION_DATE CREATION_DATE,

pbp.CREATED_BY CREATED_BY,

pbp.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pbp.LAST_UPDATED_BY LAST_UPDATED_BY,

pbp.PF_TYPE PF_TYPE,

pbp.OLD_BID_CURRENCY_VALUE OLD_BID_CURRENCY_VALUE,

pbp.REQUEST_ID REQUEST_ID,

pbp.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE,

pbp.PROGRAM_NAME PROGRAM_NAME,

pbp.PROGRAM_APP_NAME PROGRAM_APP_NAME,

pbp.BATCH_ID BATCH_ID,

pbp.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pbp.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pbp.INTERFACE_LINE_ID INTERFACE_LINE_ID,

pbp.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER

FROM

PON_BID_PRICE_ELEMENTS pbp,

PON_AUCTION_HEADERS_ALL pah,

PON_BID_HEADERS pbh

WHERE

pbp.BID_NUMBER = pbh.BID_NUMBER 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 (pah.TWO_PART_FLAG = 'Y' AND NVL(pbh.TECHNICAL_SHORTLIST_FLAG, 'N') = 'Y'))