PON_AUCTIONITEMPRICESALL_MSV

Details

• Schema: FUSION

• Object owner: PON

• Object type: VIEW

Columns

Name

AUCTION_HEADER_ID AWARD_STATUS LINE_NUMBER ITEM_DESCRIPTION CATEGORY_ID UOM_CODE QUANTITY NEED_BY_DATE SHIP_TO_LOCATION_ID NUMBER_OF_BIDS TARGET_PRICE BID_START_PRICE NOTE_TO_BIDDERS CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY CLOSE_BIDDING_DATE NUMBER_OF_EXTENSIONS DISPLAY_TARGET_PRICE_FLAG CURRENT_PRICE BEST_BID_PRICE BEST_BID_QUANTITY BEST_BID_PROMISED_DATE BEST_BID_NUMBER BEST_BID_PROXY_LIMIT_PRICE BEST_BID_CURRENCY_PRICE BEST_BID_CURRENCY_CODE PO_MIN_REL_AMOUNT BEST_BID_FIRST_BID_PRICE HAS_ATTRIBUTES_FLAG AWARDED_QUANTITY MODIFIED_FLAG BEST_BID_BID_PRICE BEST_BID_SCORE BEST_BID_BID_NUMBER BEST_BID_BID_CURRENCY_PRICE BEST_BID_BID_CURRENCY_CODE PRC_BU_ID HAS_PRICE_ELEMENTS_FLAG LINE_TYPE_ID ORDER_TYPE_LOOKUP_CODE LINE_ORIGINATION_CODE REQUISITION_NUMBER ITEM_REVISION ITEM_ID PRICE_BREAK_TYPE PRICE_BREAK_NEG_FLAG HAS_SHIPMENTS_FLAG SOURCE_DOC_NUMBER SOURCE_LINE_NUMBER SOURCE_DOC_ID SOURCE_LINE_ID ALLOCATION_STATUS PRICE_DISABLED_FLAG QUANTITY_DISABLED_FLAG JOB_ID ADDITIONAL_JOB_DETAILS PO_AGREED_AMOUNT HAS_PRICE_DIFFERENTIALS_FLAG DIFFERENTIAL_RESPONSE_TYPE PURCHASE_BASIS DISP_LINE_NUMBER LAST_UPDATE_LOGIN LAST_AMENDMENT_UPDATE MODIFIED_DATE PRICE_DIFF_SHIPMENT_NUMBER HAS_BUYER_PFS_FLAG UNIT_TARGET_PRICE UNIT_DISPLAY_TARGET_FLAG GROUP_TYPE PARENT_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER MAX_SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER AWARD_MODE HAS_PAYMENTS_FLAG ADVANCE_AMOUNT RECOUPMENT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT RETAINAGE_RATE_PERCENT MAX_RETAINAGE_AMOUNT WORK_APPROVER_USER_ID PROJECT_ID PROJECT_TASK_ID PROJECT_AWARD_ID PROJECT_EXPENDITURE_TYPE PROJECT_EXP_ORGANIZATION_ID PROJECT_EXPENDITURE_ITEM_DATE HAS_QUANTITY_TIERS OBJECT_VERSION_NUMBER REQ_BU_ID NO_AWARD INV_ORG_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ALLOW_ALTERNATE_LINES CARRIER_ID MODE_OF_TRANSPORT SERVICE_LEVEL RECOMMENDED_AWARD_AMOUNT REQUESTED_SHIP_DATE REQUESTED_DELIVERY_DATE BEST_BID_TRANS_PRICE BEST_BID_TRANS_NUMBER BEST_BID_BID_TRANS_PRICE BEST_BID_BID_TRANS_NUMBER BEST_BID_TRANS_SCORE BEST_BID_TRANS_QUANTITY MIN_BID_LINE_DECREMENT ALLOCATION_TOTAL REQUISITION_TOTAL AWARD_TOTAL

Query

SQL_Statement

SELECT pai.AUCTION_HEADER_ID AUCTION_HEADER_ID, pai.AWARD_STATUS AWARD_STATUS, pai.LINE_NUMBER LINE_NUMBER, pai.ITEM_DESCRIPTION ITEM_DESCRIPTION, pai.CATEGORY_ID CATEGORY_ID, pai.UOM_CODE UOM_CODE, pai.QUANTITY QUANTITY, pai.NEED_BY_DATE NEED_BY_DATE, pai.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, pai.NUMBER_OF_BIDS NUMBER_OF_BIDS, pai.TARGET_PRICE TARGET_PRICE, pai.BID_START_PRICE BID_START_PRICE, NVL2(pai.NOTE_TO_BIDDERS, 'Secure', NULL) NOTE_TO_BIDDERS, pai.CREATION_DATE CREATION_DATE, pai.CREATED_BY CREATED_BY, pai.LAST_UPDATE_DATE LAST_UPDATE_DATE, pai.LAST_UPDATED_BY LAST_UPDATED_BY, pai.CLOSE_BIDDING_DATE CLOSE_BIDDING_DATE, pai.NUMBER_OF_EXTENSIONS NUMBER_OF_EXTENSIONS, pai.DISPLAY_TARGET_PRICE_FLAG DISPLAY_TARGET_PRICE_FLAG, pai.CURRENT_PRICE CURRENT_PRICE, pai.BEST_BID_PRICE BEST_BID_PRICE, pai.BEST_BID_QUANTITY BEST_BID_QUANTITY, pai.BEST_BID_PROMISED_DATE BEST_BID_PROMISED_DATE, pai.BEST_BID_NUMBER BEST_BID_NUMBER, pai.BEST_BID_PROXY_LIMIT_PRICE BEST_BID_PROXY_LIMIT_PRICE, pai.BEST_BID_CURRENCY_PRICE BEST_BID_CURRENCY_PRICE, pai.BEST_BID_CURRENCY_CODE BEST_BID_CURRENCY_CODE, pai.PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, pai.BEST_BID_FIRST_BID_PRICE BEST_BID_FIRST_BID_PRICE, pai.HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG, pai.AWARDED_QUANTITY AWARDED_QUANTITY, pai.MODIFIED_FLAG MODIFIED_FLAG, pai.BEST_BID_BID_PRICE BEST_BID_BID_PRICE, pai.BEST_BID_SCORE BEST_BID_SCORE, pai.BEST_BID_BID_NUMBER BEST_BID_BID_NUMBER, pai.BEST_BID_BID_CURRENCY_PRICE BEST_BID_BID_CURRENCY_PRICE, pai.BEST_BID_BID_CURRENCY_CODE BEST_BID_BID_CURRENCY_CODE, pai.PRC_BU_ID PRC_BU_ID, pai.HAS_PRICE_ELEMENTS_FLAG HAS_PRICE_ELEMENTS_FLAG, pai.LINE_TYPE_ID LINE_TYPE_ID, pai.ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, pai.LINE_ORIGINATION_CODE LINE_ORIGINATION_CODE, pai.REQUISITION_NUMBER REQUISITION_NUMBER, pai.ITEM_REVISION ITEM_REVISION, pai.ITEM_ID ITEM_ID, pai.PRICE_BREAK_TYPE PRICE_BREAK_TYPE, pai.PRICE_BREAK_NEG_FLAG PRICE_BREAK_NEG_FLAG, pai.HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG, pai.SOURCE_DOC_NUMBER SOURCE_DOC_NUMBER, pai.SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER, pai.SOURCE_DOC_ID SOURCE_DOC_ID, pai.SOURCE_LINE_ID SOURCE_LINE_ID, pai.ALLOCATION_STATUS ALLOCATION_STATUS, pai.PRICE_DISABLED_FLAG PRICE_DISABLED_FLAG, pai.QUANTITY_DISABLED_FLAG QUANTITY_DISABLED_FLAG, pai.JOB_ID JOB_ID, pai.ADDITIONAL_JOB_DETAILS ADDITIONAL_JOB_DETAILS, pai.PO_AGREED_AMOUNT PO_AGREED_AMOUNT, pai.HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, pai.DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE, pai.PURCHASE_BASIS PURCHASE_BASIS, pai.DISP_LINE_NUMBER DISP_LINE_NUMBER, pai.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pai.LAST_AMENDMENT_UPDATE LAST_AMENDMENT_UPDATE, pai.MODIFIED_DATE MODIFIED_DATE, pai.PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER, pai.HAS_BUYER_PFS_FLAG HAS_BUYER_PFS_FLAG, pai.UNIT_TARGET_PRICE UNIT_TARGET_PRICE, pai.UNIT_DISPLAY_TARGET_FLAG UNIT_DISPLAY_TARGET_FLAG, pai.GROUP_TYPE GROUP_TYPE, pai.PARENT_LINE_NUMBER PARENT_LINE_NUMBER, pai.DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER, pai.MAX_SUB_LINE_SEQUENCE_NUMBER MAX_SUB_LINE_SEQUENCE_NUMBER, pai.SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER, pai.AWARD_MODE AWARD_MODE, pai.HAS_PAYMENTS_FLAG HAS_PAYMENTS_FLAG, pai.ADVANCE_AMOUNT ADVANCE_AMOUNT, pai.RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT, pai.PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT, pai.RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT, pai.MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, pai.WORK_APPROVER_USER_ID WORK_APPROVER_USER_ID, pai.PROJECT_ID PROJECT_ID, pai.PROJECT_TASK_ID PROJECT_TASK_ID, pai.PROJECT_AWARD_ID PROJECT_AWARD_ID, pai.PROJECT_EXPENDITURE_TYPE PROJECT_EXPENDITURE_TYPE, pai.PROJECT_EXP_ORGANIZATION_ID PROJECT_EXP_ORGANIZATION_ID, pai.PROJECT_EXPENDITURE_ITEM_DATE PROJECT_EXPENDITURE_ITEM_DATE, pai.HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS, pai.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pai.REQ_BU_ID REQ_BU_ID, pai.NO_AWARD NO_AWARD, pai.INV_ORG_ID INV_ORG_ID, pai.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, pai.ATTRIBUTE1 ATTRIBUTE1, pai.ATTRIBUTE2 ATTRIBUTE2, pai.ATTRIBUTE3 ATTRIBUTE3, pai.ATTRIBUTE4 ATTRIBUTE4, pai.ATTRIBUTE5 ATTRIBUTE5, pai.ATTRIBUTE6 ATTRIBUTE6, pai.ATTRIBUTE7 ATTRIBUTE7, pai.ATTRIBUTE8 ATTRIBUTE8, pai.ATTRIBUTE9 ATTRIBUTE9, pai.ATTRIBUTE10 ATTRIBUTE10, pai.ATTRIBUTE11 ATTRIBUTE11, pai.ATTRIBUTE12 ATTRIBUTE12, pai.ATTRIBUTE13 ATTRIBUTE13, pai.ATTRIBUTE14 ATTRIBUTE14, pai.ATTRIBUTE15 ATTRIBUTE15, pai.ATTRIBUTE16 ATTRIBUTE16, pai.ATTRIBUTE17 ATTRIBUTE17, pai.ATTRIBUTE18 ATTRIBUTE18, pai.ATTRIBUTE19 ATTRIBUTE19, pai.ATTRIBUTE20 ATTRIBUTE20, pai.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, pai.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, pai.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, pai.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, pai.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, pai.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, pai.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, pai.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, pai.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, pai.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, pai.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, pai.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, pai.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, pai.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, pai.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, pai.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6, pai.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7, pai.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8, pai.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9, pai.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10, pai.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, pai.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, pai.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, pai.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, pai.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, pai.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, pai.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, pai.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, pai.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, pai.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, pai.ALLOW_ALTERNATE_LINES ALLOW_ALTERNATE_LINES, pai.CARRIER_ID CARRIER_ID, pai.MODE_OF_TRANSPORT MODE_OF_TRANSPORT, pai.SERVICE_LEVEL SERVICE_LEVEL, pai.RECOMMENDED_AWARD_AMOUNT RECOMMENDED_AWARD_AMOUNT, pai.REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE, pai.REQUESTED_DELIVERY_DATE REQUESTED_DELIVERY_DATE, pai.BEST_BID_TRANS_PRICE BEST_BID_TRANS_PRICE, pai.BEST_BID_TRANS_NUMBER BEST_BID_TRANS_NUMBER, pai.BEST_BID_BID_TRANS_PRICE BEST_BID_BID_TRANS_PRICE, pai.BEST_BID_BID_TRANS_NUMBER BEST_BID_BID_TRANS_NUMBER, pai.BEST_BID_TRANS_SCORE BEST_BID_TRANS_SCORE, pai.BEST_BID_TRANS_QUANTITY BEST_BID_TRANS_QUANTITY, pai.MIN_BID_LINE_DECREMENT MIN_BID_LINE_DECREMENT, pai.ALLOCATION_TOTAL ALLOCATION_TOTAL, pai.REQUISITION_TOTAL REQUISITION_TOTAL, pai.AWARD_TOTAL AWARD_TOTAL FROM PON_AUCTION_ITEM_PRICES_ALL pai, PON_AUCTION_HEADERS_ALL pah WHERE pai.AUCTION_HEADER_ID = pah.AUCTION_HEADER_ID AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED'