VIEW: PON.PON_AUCTION_ITEM_PRICES_ALL#

Source

View Text - Preformatted

select AUCTION_HEADER_ID AUCTION_HEADER_ID, AWARD_STATUS AWARD_STATUS, LINE_NUMBER LINE_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, UOM_CODE UOM_CODE, QUANTITY QUANTITY, NEED_BY_DATE NEED_BY_DATE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, NUMBER_OF_BIDS NUMBER_OF_BIDS, LOWEST_BID_PRICE LOWEST_BID_PRICE, LOWEST_BID_QUANTITY LOWEST_BID_QUANTITY, LOWEST_BID_PROMISED_DATE LOWEST_BID_PROMISED_DATE, LOWEST_BID_NUMBER LOWEST_BID_NUMBER, CLOSEST_PROMISED_DATE CLOSEST_PROMISED_DATE, CLOSEST_BID_PRICE CLOSEST_BID_PRICE, CLOSEST_BID_QUANTITY CLOSEST_BID_QUANTITY, CLOSEST_BID_NUMBER CLOSEST_BID_NUMBER, TARGET_PRICE TARGET_PRICE, THRESHOLD_PRICE THRESHOLD_PRICE, BID_START_PRICE BID_START_PRICE, NOTE_TO_BIDDERS NOTE_TO_BIDDERS, ATTACHMENT_FLAG ATTACHMENT_FLAG, LANGUAGE_CODE LANGUAGE_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, AUCTION_CREATION_DATE AUCTION_CREATION_DATE, CLOSE_BIDDING_DATE CLOSE_BIDDING_DATE, NUMBER_OF_EXTENSIONS NUMBER_OF_EXTENSIONS, RESERVE_PRICE RESERVE_PRICE, DISPLAY_TARGET_PRICE_FLAG DISPLAY_TARGET_PRICE_FLAG, CURRENT_PRICE CURRENT_PRICE, BEST_BID_PRICE BEST_BID_PRICE, BEST_BID_QUANTITY BEST_BID_QUANTITY, BEST_BID_PROMISED_DATE BEST_BID_PROMISED_DATE, BEST_BID_NUMBER BEST_BID_NUMBER, TYPE TYPE, LOT_LINE_NUMBER LOT_LINE_NUMBER, MIN_BID_INCREMENT MIN_BID_INCREMENT, MIN_BID_DECREMENT MIN_BID_DECREMENT, BEST_BID_PROXY_LIMIT_PRICE BEST_BID_PROXY_LIMIT_PRICE, BEST_BID_CURRENCY_PRICE BEST_BID_CURRENCY_PRICE, BEST_BID_CURRENCY_CODE BEST_BID_CURRENCY_CODE, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, BEST_BID_FIRST_BID_PRICE BEST_BID_FIRST_BID_PRICE, UNIT_OF_MEASURE UNIT_OF_MEASURE, HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG, TRANSPORTATION_ORIGIN TRANSPORTATION_ORIGIN, TRANSPORTATION_DEST TRANSPORTATION_DEST, AUCTION_HEADER_ID_ORIG_ROUND AUCTION_HEADER_ID_ORIG_ROUND, AUCTION_HEADER_ID_PREV_ROUND AUCTION_HEADER_ID_PREV_ROUND, LINE_NUMBER_ORIGINAL_ROUND LINE_NUMBER_ORIGINAL_ROUND, LINE_NUMBER_PREV_ROUND LINE_NUMBER_PREV_ROUND, MULTIPLE_PRICES_FLAG MULTIPLE_PRICES_FLAG, RESIDUAL_QUANTITY RESIDUAL_QUANTITY, PENDING_QUANTITY PENDING_QUANTITY, CANCEL_QUANTITY CANCEL_QUANTITY, NUMBER_OF_COMMITMENTS NUMBER_OF_COMMITMENTS, NUMBER_OF_PENDING_COMMITMENTS NUMBER_OF_PENDING_COMMITMENTS, TBD_PRICING_FLAG TBD_PRICING_FLAG, NEED_BY_START_DATE NEED_BY_START_DATE, PRICE PRICE, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, AWARDED_QUANTITY AWARDED_QUANTITY, MODIFIED_FLAG MODIFIED_FLAG, BEST_BID_BID_PRICE BEST_BID_BID_PRICE, BEST_BID_SCORE BEST_BID_SCORE, BEST_BID_BID_NUMBER BEST_BID_BID_NUMBER, BEST_BID_BID_CURRENCY_PRICE BEST_BID_BID_CURRENCY_PRICE, BEST_BID_BID_CURRENCY_CODE BEST_BID_BID_CURRENCY_CODE, ORG_ID ORG_ID, HAS_PRICE_ELEMENTS_FLAG HAS_PRICE_ELEMENTS_FLAG, LINE_TYPE_ID LINE_TYPE_ID, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, LINE_ORIGINATION_CODE LINE_ORIGINATION_CODE, REQUISITION_NUMBER REQUISITION_NUMBER, ITEM_REVISION ITEM_REVISION, ITEM_ID ITEM_ID, ITEM_NUMBER ITEM_NUMBER, PRICE_BREAK_TYPE PRICE_BREAK_TYPE, PRICE_BREAK_NEG_FLAG PRICE_BREAK_NEG_FLAG, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG, SOURCE_DOC_NUMBER SOURCE_DOC_NUMBER, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER, SOURCE_DOC_ID SOURCE_DOC_ID, SOURCE_LINE_ID SOURCE_LINE_ID, ALLOCATION_STATUS ALLOCATION_STATUS, PRICE_DISABLED_FLAG PRICE_DISABLED_FLAG, QUANTITY_DISABLED_FLAG QUANTITY_DISABLED_FLAG, JOB_ID JOB_ID, ADDITIONAL_JOB_DETAILS ADDITIONAL_JOB_DETAILS, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE, PURCHASE_BASIS PURCHASE_BASIS, IS_QUANTITY_SCORED IS_QUANTITY_SCORED, IS_NEED_BY_DATE_SCORED IS_NEED_BY_DATE_SCORED, DISP_LINE_NUMBER DISP_LINE_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_AMENDMENT_UPDATE LAST_AMENDMENT_UPDATE, MODIFIED_DATE MODIFIED_DATE, PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER, HAS_BUYER_PFS_FLAG HAS_BUYER_PFS_FLAG, UNIT_TARGET_PRICE UNIT_TARGET_PRICE, UNIT_DISPLAY_TARGET_FLAG UNIT_DISPLAY_TARGET_FLAG, GROUP_TYPE GROUP_TYPE, PARENT_LINE_NUMBER PARENT_LINE_NUMBER, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER, MAX_SUB_LINE_SEQUENCE_NUMBER MAX_SUB_LINE_SEQUENCE_NUMBER, SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER, AWARD_MODE AWARD_MODE, HAS_PAYMENTS_FLAG HAS_PAYMENTS_FLAG, ADVANCE_AMOUNT ADVANCE_AMOUNT, RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT, PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT, RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT, WORK_APPROVER_USER_ID WORK_APPROVER_USER_ID, PROJECT_ID PROJECT_ID, PROJECT_TASK_ID PROJECT_TASK_ID, PROJECT_AWARD_ID PROJECT_AWARD_ID, PROJECT_EXPENDITURE_TYPE PROJECT_EXPENDITURE_TYPE, PROJECT_EXP_ORGANIZATION_ID PROJECT_EXP_ORGANIZATION_ID, PROJECT_EXPENDITURE_ITEM_DATE PROJECT_EXPENDITURE_ITEM_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BATCH_ID BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, IP_CATEGORY_ID IP_CATEGORY_ID, HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM, CLM_FUNDED_FLAG CLM_FUNDED_FLAG, CLM_INFO_FLAG CLM_INFO_FLAG, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR, CLM_OPTION_NUM CLM_OPTION_NUM, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE, GROUP_LINE_ID GROUP_LINE_ID, LINE_NUM_DISPLAY LINE_NUM_DISPLAY, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, CLM_UNIT_PRICE CLM_UNIT_PRICE, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT, CLM_IDC_TYPE CLM_IDC_TYPE, CLM_AMOUNT CLM_AMOUNT, CLM_NEED_BY_DATE CLM_NEED_BY_DATE, EXHIBIT_NUMBER EXHIBIT_NUMBER, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM, CLM_POP_DURATION CLM_POP_DURATION, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM from "PON"."PON_AUCTION_ITEM_PRICES_ALL"

View Text - HTML Formatted

SELECT AUCTION_HEADER_ID AUCTION_HEADER_ID
, AWARD_STATUS AWARD_STATUS
, LINE_NUMBER LINE_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, UOM_CODE UOM_CODE
, QUANTITY QUANTITY
, NEED_BY_DATE NEED_BY_DATE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, NUMBER_OF_BIDS NUMBER_OF_BIDS
, LOWEST_BID_PRICE LOWEST_BID_PRICE
, LOWEST_BID_QUANTITY LOWEST_BID_QUANTITY
, LOWEST_BID_PROMISED_DATE LOWEST_BID_PROMISED_DATE
, LOWEST_BID_NUMBER LOWEST_BID_NUMBER
, CLOSEST_PROMISED_DATE CLOSEST_PROMISED_DATE
, CLOSEST_BID_PRICE CLOSEST_BID_PRICE
, CLOSEST_BID_QUANTITY CLOSEST_BID_QUANTITY
, CLOSEST_BID_NUMBER CLOSEST_BID_NUMBER
, TARGET_PRICE TARGET_PRICE
, THRESHOLD_PRICE THRESHOLD_PRICE
, BID_START_PRICE BID_START_PRICE
, NOTE_TO_BIDDERS NOTE_TO_BIDDERS
, ATTACHMENT_FLAG ATTACHMENT_FLAG
, LANGUAGE_CODE LANGUAGE_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, AUCTION_CREATION_DATE AUCTION_CREATION_DATE
, CLOSE_BIDDING_DATE CLOSE_BIDDING_DATE
, NUMBER_OF_EXTENSIONS NUMBER_OF_EXTENSIONS
, RESERVE_PRICE RESERVE_PRICE
, DISPLAY_TARGET_PRICE_FLAG DISPLAY_TARGET_PRICE_FLAG
, CURRENT_PRICE CURRENT_PRICE
, BEST_BID_PRICE BEST_BID_PRICE
, BEST_BID_QUANTITY BEST_BID_QUANTITY
, BEST_BID_PROMISED_DATE BEST_BID_PROMISED_DATE
, BEST_BID_NUMBER BEST_BID_NUMBER
, TYPE TYPE
, LOT_LINE_NUMBER LOT_LINE_NUMBER
, MIN_BID_INCREMENT MIN_BID_INCREMENT
, MIN_BID_DECREMENT MIN_BID_DECREMENT
, BEST_BID_PROXY_LIMIT_PRICE BEST_BID_PROXY_LIMIT_PRICE
, BEST_BID_CURRENCY_PRICE BEST_BID_CURRENCY_PRICE
, BEST_BID_CURRENCY_CODE BEST_BID_CURRENCY_CODE
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, BEST_BID_FIRST_BID_PRICE BEST_BID_FIRST_BID_PRICE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG
, TRANSPORTATION_ORIGIN TRANSPORTATION_ORIGIN
, TRANSPORTATION_DEST TRANSPORTATION_DEST
, AUCTION_HEADER_ID_ORIG_ROUND AUCTION_HEADER_ID_ORIG_ROUND
, AUCTION_HEADER_ID_PREV_ROUND AUCTION_HEADER_ID_PREV_ROUND
, LINE_NUMBER_ORIGINAL_ROUND LINE_NUMBER_ORIGINAL_ROUND
, LINE_NUMBER_PREV_ROUND LINE_NUMBER_PREV_ROUND
, MULTIPLE_PRICES_FLAG MULTIPLE_PRICES_FLAG
, RESIDUAL_QUANTITY RESIDUAL_QUANTITY
, PENDING_QUANTITY PENDING_QUANTITY
, CANCEL_QUANTITY CANCEL_QUANTITY
, NUMBER_OF_COMMITMENTS NUMBER_OF_COMMITMENTS
, NUMBER_OF_PENDING_COMMITMENTS NUMBER_OF_PENDING_COMMITMENTS
, TBD_PRICING_FLAG TBD_PRICING_FLAG
, NEED_BY_START_DATE NEED_BY_START_DATE
, PRICE PRICE
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, AWARDED_QUANTITY AWARDED_QUANTITY
, MODIFIED_FLAG MODIFIED_FLAG
, BEST_BID_BID_PRICE BEST_BID_BID_PRICE
, BEST_BID_SCORE BEST_BID_SCORE
, BEST_BID_BID_NUMBER BEST_BID_BID_NUMBER
, BEST_BID_BID_CURRENCY_PRICE BEST_BID_BID_CURRENCY_PRICE
, BEST_BID_BID_CURRENCY_CODE BEST_BID_BID_CURRENCY_CODE
, ORG_ID ORG_ID
, HAS_PRICE_ELEMENTS_FLAG HAS_PRICE_ELEMENTS_FLAG
, LINE_TYPE_ID LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, LINE_ORIGINATION_CODE LINE_ORIGINATION_CODE
, REQUISITION_NUMBER REQUISITION_NUMBER
, ITEM_REVISION ITEM_REVISION
, ITEM_ID ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, PRICE_BREAK_TYPE PRICE_BREAK_TYPE
, PRICE_BREAK_NEG_FLAG PRICE_BREAK_NEG_FLAG
, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG
, SOURCE_DOC_NUMBER SOURCE_DOC_NUMBER
, SOURCE_LINE_NUMBER SOURCE_LINE_NUMBER
, SOURCE_DOC_ID SOURCE_DOC_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, ALLOCATION_STATUS ALLOCATION_STATUS
, PRICE_DISABLED_FLAG PRICE_DISABLED_FLAG
, QUANTITY_DISABLED_FLAG QUANTITY_DISABLED_FLAG
, JOB_ID JOB_ID
, ADDITIONAL_JOB_DETAILS ADDITIONAL_JOB_DETAILS
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG
, DIFFERENTIAL_RESPONSE_TYPE DIFFERENTIAL_RESPONSE_TYPE
, PURCHASE_BASIS PURCHASE_BASIS
, IS_QUANTITY_SCORED IS_QUANTITY_SCORED
, IS_NEED_BY_DATE_SCORED IS_NEED_BY_DATE_SCORED
, DISP_LINE_NUMBER DISP_LINE_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_AMENDMENT_UPDATE LAST_AMENDMENT_UPDATE
, MODIFIED_DATE MODIFIED_DATE
, PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER
, HAS_BUYER_PFS_FLAG HAS_BUYER_PFS_FLAG
, UNIT_TARGET_PRICE UNIT_TARGET_PRICE
, UNIT_DISPLAY_TARGET_FLAG UNIT_DISPLAY_TARGET_FLAG
, GROUP_TYPE GROUP_TYPE
, PARENT_LINE_NUMBER PARENT_LINE_NUMBER
, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER
, MAX_SUB_LINE_SEQUENCE_NUMBER MAX_SUB_LINE_SEQUENCE_NUMBER
, SUB_LINE_SEQUENCE_NUMBER SUB_LINE_SEQUENCE_NUMBER
, AWARD_MODE AWARD_MODE
, HAS_PAYMENTS_FLAG HAS_PAYMENTS_FLAG
, ADVANCE_AMOUNT ADVANCE_AMOUNT
, RECOUPMENT_RATE_PERCENT RECOUPMENT_RATE_PERCENT
, PROGRESS_PYMT_RATE_PERCENT PROGRESS_PYMT_RATE_PERCENT
, RETAINAGE_RATE_PERCENT RETAINAGE_RATE_PERCENT
, MAX_RETAINAGE_AMOUNT MAX_RETAINAGE_AMOUNT
, WORK_APPROVER_USER_ID WORK_APPROVER_USER_ID
, PROJECT_ID PROJECT_ID
, PROJECT_TASK_ID PROJECT_TASK_ID
, PROJECT_AWARD_ID PROJECT_AWARD_ID
, PROJECT_EXPENDITURE_TYPE PROJECT_EXPENDITURE_TYPE
, PROJECT_EXP_ORGANIZATION_ID PROJECT_EXP_ORGANIZATION_ID
, PROJECT_EXPENDITURE_ITEM_DATE PROJECT_EXPENDITURE_ITEM_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BATCH_ID BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, IP_CATEGORY_ID IP_CATEGORY_ID
, HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS
, CLM_BASE_LINE_NUM CLM_BASE_LINE_NUM
, CLM_FUNDED_FLAG CLM_FUNDED_FLAG
, CLM_INFO_FLAG CLM_INFO_FLAG
, CLM_OPTION_FROM_DATE CLM_OPTION_FROM_DATE
, CLM_OPTION_INDICATOR CLM_OPTION_INDICATOR
, CLM_OPTION_NUM CLM_OPTION_NUM
, CLM_OPTION_TO_DATE CLM_OPTION_TO_DATE
, GROUP_LINE_ID GROUP_LINE_ID
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, CLM_UNIT_PRICE CLM_UNIT_PRICE
, CLM_CONTRACT_TYPE CLM_CONTRACT_TYPE
, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT
, CLM_IDC_TYPE CLM_IDC_TYPE
, CLM_AMOUNT CLM_AMOUNT
, CLM_NEED_BY_DATE CLM_NEED_BY_DATE
, EXHIBIT_NUMBER EXHIBIT_NUMBER
, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE
, CLM_DELIVERY_PERIOD CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM CLM_DELIVERY_PERIOD_UOM
, CLM_POP_DURATION CLM_POP_DURATION
, CLM_POP_DURATION_UOM CLM_POP_DURATION_UOM
FROM "PON"."PON_AUCTION_ITEM_PRICES_ALL"