PON_BID_ITEM_PRICES_MSV

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name

AUCTION_HEADER_ID BID_NUMBER LINE_NUMBER PURCHASING_ITEM_ID PURCHASING_ITEM_REVISION PURCHASING_ITEM_DESC QUANTITY PRICE PROMISED_DATE AWARD_STATUS AWARD_DATE AWARD_QUANTITY NOTE_TO_AUCTION_OWNER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY PUBLISH_DATE PROXY_BID_LIMIT_PRICE BID_CURRENCY_PRICE BID_CURRENCY_LIMIT_PRICE PROXY_BID_FLAG FIRST_BID_PRICE HAS_ATTRIBUTES_FLAG TOTAL_WEIGHTED_SCORE RANK TRIGGER_BID_NUMBER PO_MIN_REL_AMOUNT PO_BID_MIN_REL_AMOUNT PRICE_BREAK_TYPE HAS_SHIPMENTS_FLAG CANCELLED_LIMIT_PRICE IS_CHANGED_LINE_FLAG HAS_PRICE_DIFFERENTIALS_FLAG PRICE_DIFF_SHIPMENT_NUMBER BID_CURRENCY_TRANS_PRICE UNIT_PRICE BID_CURRENCY_UNIT_PRICE GROUP_AMOUNT HAS_BID_PAYMENTS_FLAG ADVANCE_AMOUNT BID_CURR_ADVANCE_AMOUNT RECOUPMENT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT RETAINAGE_RATE_PERCENT MAX_RETAINAGE_AMOUNT BID_CURR_MAX_RETAINAGE_AMT OLD_NO_OF_PAYMENTS OLD_BID_CURR_ADVANCE_AMOUNT OLD_RECOUPMENT_RATE_PERCENT OLD_PROGRESS_PYMT_RATE_PERCENT OLD_RETAINAGE_RATE_PERCENT OLD_BID_CURR_MAX_RETAINAGE_AMT OLD_PRICE OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_PRICE OLD_BID_CURRENCY_LIMIT_PRICE OLD_PO_BID_MIN_REL_AMOUNT OLD_QUANTITY OLD_PUBLISH_DATE OLD_PROMISED_DATE OLD_NOTE_TO_AUCTION_OWNER HAS_BID_FLAG DISPLAY_PRICE_FACTORS_FLAG REQUEST_ID PROGRAM_UPDATE_DATE PROGRAM_NAME PROGRAM_APP_NAME BATCH_ID INTERFACE_LINE_ID COPY_PRICE_FOR_PROXY_FLAG AWARD_PRICE AWARD_SHIPMENT_NUMBER HAS_QUANTITY_TIERS PER_UNIT_PRICE_COMPONENT FIXED_AMOUNT_COMPONENT BID_START_PRICE OBJECT_VERSION_NUMBER WORKSHEET_NAME WORKSHEET_SEQUENCE_NUMBER LAST_UPDATE_LOGIN PARENT_LINE_NUMBER ALTERNATE_DISP_LINE_NUMBER AUCTION_LINE_NUMBER ALTERNATE_LINE_DESCRIPTION OLD_ALTERNATE_LINE_DESCRIPTION UOM_CODE OLD_UOM_CODE UOM_CONVERSION_FACTOR DOCUMENT_DISP_LINE_NUMBER MAX_ALTERNATE_DISP_LINE_NUMBER ALTERNATE_LINE_FLAG PROMISED_SHIP_DATE OLD_PROMISED_SHIP_DATE PROMISED_DELIVERY_DATE OLD_PROMISED_DELIVERY_DATE TRANS_GROUP_AMOUNT TOTAL_FIXED_ICF_LINE_COST TOTAL_PER_UNIT_ICF_LINE_COST TOTAL_PERCENT_ICF_LINE_COST TRANS_RESPONSE_PRICE TRANS_LINE_AMOUNT TRANS_RANK MIN_BID_LINE_CHANGE OLD_MIN_BID_LINE_CHANGE BID_CURR_MIN_BID_LINE_CHANGE OLD_BID_CUR_MIN_BID_LIN_CHANGE SUPP_ITEM_ID MFG_PART_ITEM_ID MFG_PARTY_ID OLD_SUPP_ITEM_ID OLD_MFG_PART_ITEM_ID OLD_MFG_PARTY_ID NEW_SUPP_ITEM_NUMBER OLD_NEW_SUPP_ITEM_NUMBER

Query

SQL_Statement

SELECT pbip.AUCTION_HEADER_ID AUCTION_HEADER_ID, pbip.BID_NUMBER BID_NUMBER, pbip.LINE_NUMBER LINE_NUMBER, pbip.PURCHASING_ITEM_ID PURCHASING_ITEM_ID, pbip.PURCHASING_ITEM_REVISION PURCHASING_ITEM_REVISION, pbip.PURCHASING_ITEM_DESC PURCHASING_ITEM_DESC, pbip.QUANTITY QUANTITY, pbip.PRICE PRICE, pbip.PROMISED_DATE PROMISED_DATE, pbip.AWARD_STATUS AWARD_STATUS, pbip.AWARD_DATE AWARD_DATE, pbip.AWARD_QUANTITY AWARD_QUANTITY, NVL2(pbip.NOTE_TO_AUCTION_OWNER, 'Secure', NULL) NOTE_TO_AUCTION_OWNER, pbip.CREATION_DATE CREATION_DATE, pbip.CREATED_BY CREATED_BY, pbip.LAST_UPDATE_DATE LAST_UPDATE_DATE, pbip.LAST_UPDATED_BY LAST_UPDATED_BY, pbip.PUBLISH_DATE PUBLISH_DATE, pbip.PROXY_BID_LIMIT_PRICE PROXY_BID_LIMIT_PRICE, pbip.BID_CURRENCY_PRICE BID_CURRENCY_PRICE, pbip.BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE, pbip.PROXY_BID_FLAG PROXY_BID_FLAG, pbip.FIRST_BID_PRICE FIRST_BID_PRICE, pbip.HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG, pbip.TOTAL_WEIGHTED_SCORE TOTAL_WEIGHTED_SCORE, pbip.RANK RANK, pbip.TRIGGER_BID_NUMBER TRIGGER_BID_NUMBER, pbip.PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, pbip.PO_BID_MIN_REL_AMOUNT PO_BID_MIN_REL_AMOUNT, pbip.PRICE_BREAK_TYPE PRICE_BREAK_TYPE, pbip.HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG, pbip.CANCELLED_LIMIT_PRICE CANCELLED_LIMIT_PRICE, pbip.IS_CHANGED_LINE_FLAG IS_CHANGED_LINE_FLAG, pbip.HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, pbip.PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER, pbip.BID_CURRENCY_TRANS_PRICE BID_CURRENCY_TRANS_PRICE, pbip.UNIT_PRICE UNIT_PRICE, pbip.BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE, pbip.GROUP_AMOUNT GROUP_AMOUNT, pbip.HAS_BID_PAYMENTS_FLAG HAS_BID_PAYMENTS_FLAG, pbip.ADVANCE_AMOUNT ADVANCE_AMOUNT, pbip.BID_CURR_ADVANCE_AMOUNT BID_CURR_ADVANCE_AMOUNT, pbip.RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT, pbip.PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT, pbip.RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT, pbip.MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, pbip.BID_CURR_MAX_RETAINAGE_AMT BID_CURR_MAX_RETAINAGE_AMT, pbip.OLD_NO_OF_PAYMENTS OLD_NO_OF_PAYMENTS, pbip.OLD_BID_CURR_ADVANCE_AMOUNT OLD_BID_CURR_ADVANCE_AMOUNT, pbip.OLD_RECOUPMENT_RATE_PERCENT OLD_RECOUPMENT_RATE_PERCENT, pbip.OLD_PROGRESS_PYMT_RATE_PERCENT OLD_PROGRESS_PYMT_RATE_PERCENT, pbip.OLD_RETAINAGE_RATE_PERCENT OLD_RETAINAGE_RATE_PERCENT, pbip.OLD_BID_CURR_MAX_RETAINAGE_AMT OLD_BID_CURR_MAX_RETAINAGE_AMT, pbip.OLD_PRICE OLD_PRICE, pbip.OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_UNIT_PRICE, pbip.OLD_BID_CURRENCY_PRICE OLD_BID_CURRENCY_PRICE, pbip.OLD_BID_CURRENCY_LIMIT_PRICE OLD_BID_CURRENCY_LIMIT_PRICE, pbip.OLD_PO_BID_MIN_REL_AMOUNT OLD_PO_BID_MIN_REL_AMOUNT, pbip.OLD_QUANTITY OLD_QUANTITY, pbip.OLD_PUBLISH_DATE OLD_PUBLISH_DATE, pbip.OLD_PROMISED_DATE OLD_PROMISED_DATE, NVL2(pbip.OLD_NOTE_TO_AUCTION_OWNER, 'Secure', NULL) OLD_NOTE_TO_AUCTION_OWNER, pbip.HAS_BID_FLAG HAS_BID_FLAG, pbip.DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG, pbip.REQUEST_ID REQUEST_ID, pbip.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, pbip.PROGRAM_NAME PROGRAM_NAME, pbip.PROGRAM_APP_NAME PROGRAM_APP_NAME, pbip.BATCH_ID BATCH_ID, pbip.INTERFACE_LINE_ID INTERFACE_LINE_ID, pbip.COPY_PRICE_FOR_PROXY_FLAG COPY_PRICE_FOR_PROXY_FLAG, pbip.AWARD_PRICE AWARD_PRICE, pbip.AWARD_SHIPMENT_NUMBER AWARD_SHIPMENT_NUMBER, pbip.HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS, pbip.PER_UNIT_PRICE_COMPONENT PER_UNIT_PRICE_COMPONENT, pbip.FIXED_AMOUNT_COMPONENT FIXED_AMOUNT_COMPONENT, pbip.BID_START_PRICE BID_START_PRICE, pbip.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pbip.WORKSHEET_NAME WORKSHEET_NAME, pbip.WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER, pbip.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pbip.PARENT_LINE_NUMBER PARENT_LINE_NUMBER, pbip.ALTERNATE_DISP_LINE_NUMBER ALTERNATE_DISP_LINE_NUMBER, pbip.AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, pbip.ALTERNATE_LINE_DESCRIPTION ALTERNATE_LINE_DESCRIPTION, pbip.OLD_ALTERNATE_LINE_DESCRIPTION OLD_ALTERNATE_LINE_DESCRIPTION, pbip.UOM_CODE UOM_CODE, pbip.OLD_UOM_CODE OLD_UOM_CODE, pbip.UOM_CONVERSION_FACTOR UOM_CONVERSION_FACTOR, pbip.DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER, pbip.MAX_ALTERNATE_DISP_LINE_NUMBER MAX_ALTERNATE_DISP_LINE_NUMBER, pbip.ALTERNATE_LINE_FLAG ALTERNATE_LINE_FLAG, pbip.PROMISED_SHIP_DATE PROMISED_SHIP_DATE, pbip.OLD_PROMISED_SHIP_DATE OLD_PROMISED_SHIP_DATE, pbip.PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE, pbip.OLD_PROMISED_DELIVERY_DATE OLD_PROMISED_DELIVERY_DATE, pbip.TRANS_GROUP_AMOUNT TRANS_GROUP_AMOUNT, pbip.TOTAL_FIXED_ICF_LINE_COST TOTAL_FIXED_ICF_LINE_COST, pbip.TOTAL_PER_UNIT_ICF_LINE_COST TOTAL_PER_UNIT_ICF_LINE_COST, pbip.TOTAL_PERCENT_ICF_LINE_COST TOTAL_PERCENT_ICF_LINE_COST, pbip.TRANS_RESPONSE_PRICE TRANS_RESPONSE_PRICE, pbip.TRANS_LINE_AMOUNT TRANS_LINE_AMOUNT, pbip.TRANS_RANK TRANS_RANK, pbip.MIN_BID_LINE_CHANGE, pbip.OLD_MIN_BID_LINE_CHANGE, pbip.BID_CURR_MIN_BID_LINE_CHANGE, pbip.OLD_BID_CUR_MIN_BID_LIN_CHANGE, pbip.SUPP_ITEM_ID, pbip.MFG_PART_ITEM_ID, pbip.MFG_PARTY_ID, pbip.OLD_SUPP_ITEM_ID, pbip.OLD_MFG_PART_ITEM_ID, pbip.OLD_MFG_PARTY_ID, pbip.NEW_SUPP_ITEM_NUMBER, pbip.OLD_NEW_SUPP_ITEM_NUMBER FROM PON_BID_ITEM_PRICES pbip, PON_AUCTION_HEADERS_ALL pah, PON_BID_HEADERS pbh WHERE pbip.BID_NUMBER = pbh.BID_NUMBER AND pbh.AUCTION_HEADER_ID = pah.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'))