eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PON.PON_BID_ITEM_PRICES#

Source

View Text - Preformatted


select AUCTION_HEADER_ID AUCTION_HEADER_ID, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER, BID_NUMBER BID_NUMBER, LINE_NUMBER LINE_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, UOM UOM, QUANTITY QUANTITY, PRICE PRICE, MINIMUM_BID_PRICE MINIMUM_BID_PRICE, PROMISED_DATE PROMISED_DATE, AWARD_STATUS AWARD_STATUS, AWARD_STATUS_NAME AWARD_STATUS_NAME, AWARD_DATE AWARD_DATE, AWARD_QUANTITY AWARD_QUANTITY, ORDER_NUMBER#1 ORDER_NUMBER, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER, ATTACHMENTS_FLAG ATTACHMENTS_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, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PUBLISH_DATE PUBLISH_DATE, PROXY_BID_LIMIT_PRICE PROXY_BID_LIMIT_PRICE, PROXY_BID_LIMIT_PRICE_DATE PROXY_BID_LIMIT_PRICE_DATE, BID_CURRENCY_PRICE BID_CURRENCY_PRICE, AUCTION_LINE_TYPE AUCTION_LINE_TYPE, AUCTION_LOT_LINE_NUMBER AUCTION_LOT_LINE_NUMBER, LOT_LINE_NUMBER LOT_LINE_NUMBER, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE, PROXY_BID_FLAG PROXY_BID_FLAG, FIRST_BID_PRICE FIRST_BID_PRICE, UNIT_OF_MEASURE UNIT_OF_MEASURE, HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND, COUNTER_PRICE_NUMBER COUNTER_PRICE_NUMBER, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, TBD_PRICING_FLAG TBD_PRICING_FLAG, AUC_TRADING_PARTNER_ID AUC_TRADING_PARTNER_ID, BID_TRADING_PARTNER_ID BID_TRADING_PARTNER_ID, TOTAL_WEIGHTED_SCORE TOTAL_WEIGHTED_SCORE, RANK RANK, TRIGGER_BID_NUMBER TRIGGER_BID_NUMBER, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, PO_BID_MIN_REL_AMOUNT PO_BID_MIN_REL_AMOUNT, PRICE_BREAK_TYPE PRICE_BREAK_TYPE, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG, CANCELLED_LIMIT_PRICE CANCELLED_LIMIT_PRICE, IS_CHANGED_LINE_FLAG IS_CHANGED_LINE_FLAG, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG, PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER, BID_CURRENCY_TRANS_PRICE BID_CURRENCY_TRANS_PRICE, UNIT_PRICE UNIT_PRICE, BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE, GROUP_AMOUNT GROUP_AMOUNT, HAS_BID_PAYMENTS_FLAG HAS_BID_PAYMENTS_FLAG, ADVANCE_AMOUNT ADVANCE_AMOUNT, BID_CURR_ADVANCE_AMOUNT BID_CURR_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, BID_CURR_MAX_RETAINAGE_AMT BID_CURR_MAX_RETAINAGE_AMT, OLD_NO_OF_PAYMENTS OLD_NO_OF_PAYMENTS, OLD_BID_CURR_ADVANCE_AMOUNT OLD_BID_CURR_ADVANCE_AMOUNT, OLD_RECOUPMENT_RATE_PERCENT OLD_RECOUPMENT_RATE_PERCENT, OLD_PROGRESS_PYMT_RATE_PERCENT OLD_PROGRESS_PYMT_RATE_PERCENT, OLD_RETAINAGE_RATE_PERCENT OLD_RETAINAGE_RATE_PERCENT, OLD_BID_CURR_MAX_RETAINAGE_AMT OLD_BID_CURR_MAX_RETAINAGE_AMT, OLD_PRICE OLD_PRICE, OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_UNIT_PRICE, OLD_BID_CURRENCY_PRICE OLD_BID_CURRENCY_PRICE, OLD_BID_CURRENCY_LIMIT_PRICE OLD_BID_CURRENCY_LIMIT_PRICE, OLD_PO_BID_MIN_REL_AMOUNT OLD_PO_BID_MIN_REL_AMOUNT, OLD_QUANTITY OLD_QUANTITY, OLD_PUBLISH_DATE OLD_PUBLISH_DATE, OLD_PROMISED_DATE OLD_PROMISED_DATE, OLD_NOTE_TO_AUCTION_OWNER OLD_NOTE_TO_AUCTION_OWNER, HAS_BID_FLAG HAS_BID_FLAG, DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG, 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, COPY_PRICE_FOR_PROXY_FLAG COPY_PRICE_FOR_PROXY_FLAG, AWARD_PRICE AWARD_PRICE, AWARD_SHIPMENT_NUMBER AWARD_SHIPMENT_NUMBER, HAS_QUANITITY_TIERS HAS_QUANITITY_TIERS, PER_UNIT_PRICE_COMPONENT PER_UNIT_PRICE_COMPONENT, FIXED_AMOUNT_COMPONENT FIXED_AMOUNT_COMPONENT, BID_START_PRICE BID_START_PRICE, HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS, WORKSHEET_NAME WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER, APPROVAL_STATUS APPROVAL_STATUS, 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_CONTRACT_TYPE CLM_CONTRACT_TYPE, CLM_IDC_TYPE CLM_IDC_TYPE, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT, IDV_LINE_ID IDV_LINE_ID, PROMISE_POP_START_DATE PROMISE_POP_START_DATE, PROMISE_POP_END_DATE PROMISE_POP_END_DATE, LINE_TYPE_ID LINE_TYPE_ID, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE, PURCHASE_BASIS PURCHASE_BASIS, CLM_AMOUNT CLM_AMOUNT, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM, CLM_PROMISE_POP_DURATION CLM_PROMISE_POP_DURATION, CLM_PROMISE_POP_DURATION_UOM CLM_PROMISE_POP_DURATION_UOM, HAS_USER_BID_FLAG HAS_USER_BID_FLAG, USER_MARKED_FLAG USER_MARKED_FLAG, IS_REBID_ON_LINE_FLAG IS_REBID_ON_LINE_FLAG, PO_TXN_FLAG PO_TXN_FLAG, PO_HEADER_ID PO_HEADER_ID, PO_WF_CREATION_RND PO_WF_CREATION_RND, PO_ERROR_CODE PO_ERROR_CODE, PO_START_DATE PO_START_DATE, PO_END_DATE PO_END_DATE, INITIATE_APPROVAL INITIATE_APPROVAL, PO_ERROR_MSG PO_ERROR_MSG from "PON"."PON_BID_ITEM_PRICES"

View Text - HTML Formatted

SELECT AUCTION_HEADER_ID AUCTION_HEADER_ID
, AUCTION_LINE_NUMBER AUCTION_LINE_NUMBER
, BID_NUMBER BID_NUMBER
, LINE_NUMBER LINE_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, UOM UOM
, QUANTITY QUANTITY
, PRICE PRICE
, MINIMUM_BID_PRICE MINIMUM_BID_PRICE
, PROMISED_DATE PROMISED_DATE
, AWARD_STATUS AWARD_STATUS
, AWARD_STATUS_NAME AWARD_STATUS_NAME
, AWARD_DATE AWARD_DATE
, AWARD_QUANTITY AWARD_QUANTITY
, ORDER_NUMBER#1 ORDER_NUMBER
, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER
, ATTACHMENTS_FLAG ATTACHMENTS_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
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PUBLISH_DATE PUBLISH_DATE
, PROXY_BID_LIMIT_PRICE PROXY_BID_LIMIT_PRICE
, PROXY_BID_LIMIT_PRICE_DATE PROXY_BID_LIMIT_PRICE_DATE
, BID_CURRENCY_PRICE BID_CURRENCY_PRICE
, AUCTION_LINE_TYPE AUCTION_LINE_TYPE
, AUCTION_LOT_LINE_NUMBER AUCTION_LOT_LINE_NUMBER
, LOT_LINE_NUMBER LOT_LINE_NUMBER
, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE
, PROXY_BID_FLAG PROXY_BID_FLAG
, FIRST_BID_PRICE FIRST_BID_PRICE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, HAS_ATTRIBUTES_FLAG HAS_ATTRIBUTES_FLAG
, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND
, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND
, COUNTER_PRICE_NUMBER COUNTER_PRICE_NUMBER
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, TBD_PRICING_FLAG TBD_PRICING_FLAG
, AUC_TRADING_PARTNER_ID AUC_TRADING_PARTNER_ID
, BID_TRADING_PARTNER_ID BID_TRADING_PARTNER_ID
, TOTAL_WEIGHTED_SCORE TOTAL_WEIGHTED_SCORE
, RANK RANK
, TRIGGER_BID_NUMBER TRIGGER_BID_NUMBER
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, PO_BID_MIN_REL_AMOUNT PO_BID_MIN_REL_AMOUNT
, PRICE_BREAK_TYPE PRICE_BREAK_TYPE
, HAS_SHIPMENTS_FLAG HAS_SHIPMENTS_FLAG
, CANCELLED_LIMIT_PRICE CANCELLED_LIMIT_PRICE
, IS_CHANGED_LINE_FLAG IS_CHANGED_LINE_FLAG
, HAS_PRICE_DIFFERENTIALS_FLAG HAS_PRICE_DIFFERENTIALS_FLAG
, PRICE_DIFF_SHIPMENT_NUMBER PRICE_DIFF_SHIPMENT_NUMBER
, BID_CURRENCY_TRANS_PRICE BID_CURRENCY_TRANS_PRICE
, UNIT_PRICE UNIT_PRICE
, BID_CURRENCY_UNIT_PRICE BID_CURRENCY_UNIT_PRICE
, GROUP_AMOUNT GROUP_AMOUNT
, HAS_BID_PAYMENTS_FLAG HAS_BID_PAYMENTS_FLAG
, ADVANCE_AMOUNT ADVANCE_AMOUNT
, BID_CURR_ADVANCE_AMOUNT BID_CURR_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
, BID_CURR_MAX_RETAINAGE_AMT BID_CURR_MAX_RETAINAGE_AMT
, OLD_NO_OF_PAYMENTS OLD_NO_OF_PAYMENTS
, OLD_BID_CURR_ADVANCE_AMOUNT OLD_BID_CURR_ADVANCE_AMOUNT
, OLD_RECOUPMENT_RATE_PERCENT OLD_RECOUPMENT_RATE_PERCENT
, OLD_PROGRESS_PYMT_RATE_PERCENT OLD_PROGRESS_PYMT_RATE_PERCENT
, OLD_RETAINAGE_RATE_PERCENT OLD_RETAINAGE_RATE_PERCENT
, OLD_BID_CURR_MAX_RETAINAGE_AMT OLD_BID_CURR_MAX_RETAINAGE_AMT
, OLD_PRICE OLD_PRICE
, OLD_BID_CURRENCY_UNIT_PRICE OLD_BID_CURRENCY_UNIT_PRICE
, OLD_BID_CURRENCY_PRICE OLD_BID_CURRENCY_PRICE
, OLD_BID_CURRENCY_LIMIT_PRICE OLD_BID_CURRENCY_LIMIT_PRICE
, OLD_PO_BID_MIN_REL_AMOUNT OLD_PO_BID_MIN_REL_AMOUNT
, OLD_QUANTITY OLD_QUANTITY
, OLD_PUBLISH_DATE OLD_PUBLISH_DATE
, OLD_PROMISED_DATE OLD_PROMISED_DATE
, OLD_NOTE_TO_AUCTION_OWNER OLD_NOTE_TO_AUCTION_OWNER
, HAS_BID_FLAG HAS_BID_FLAG
, DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG
, 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
, COPY_PRICE_FOR_PROXY_FLAG COPY_PRICE_FOR_PROXY_FLAG
, AWARD_PRICE AWARD_PRICE
, AWARD_SHIPMENT_NUMBER AWARD_SHIPMENT_NUMBER
, HAS_QUANITITY_TIERS HAS_QUANITITY_TIERS
, PER_UNIT_PRICE_COMPONENT PER_UNIT_PRICE_COMPONENT
, FIXED_AMOUNT_COMPONENT FIXED_AMOUNT_COMPONENT
, BID_START_PRICE BID_START_PRICE
, HAS_QUANTITY_TIERS HAS_QUANTITY_TIERS
, WORKSHEET_NAME WORKSHEET_NAME
, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER
, APPROVAL_STATUS APPROVAL_STATUS
, 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_CONTRACT_TYPE CLM_CONTRACT_TYPE
, CLM_IDC_TYPE CLM_IDC_TYPE
, CLM_COST_CONSTRAINT CLM_COST_CONSTRAINT
, IDV_LINE_ID IDV_LINE_ID
, PROMISE_POP_START_DATE PROMISE_POP_START_DATE
, PROMISE_POP_END_DATE PROMISE_POP_END_DATE
, LINE_TYPE_ID LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS PURCHASE_BASIS
, CLM_AMOUNT CLM_AMOUNT
, CLM_DELIVERY_EVENT_CODE CLM_DELIVERY_EVENT_CODE
, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM
, CLM_PROMISE_POP_DURATION CLM_PROMISE_POP_DURATION
, CLM_PROMISE_POP_DURATION_UOM CLM_PROMISE_POP_DURATION_UOM
, HAS_USER_BID_FLAG HAS_USER_BID_FLAG
, USER_MARKED_FLAG USER_MARKED_FLAG
, IS_REBID_ON_LINE_FLAG IS_REBID_ON_LINE_FLAG
, PO_TXN_FLAG PO_TXN_FLAG
, PO_HEADER_ID PO_HEADER_ID
, PO_WF_CREATION_RND PO_WF_CREATION_RND
, PO_ERROR_CODE PO_ERROR_CODE
, PO_START_DATE PO_START_DATE
, PO_END_DATE PO_END_DATE
, INITIATE_APPROVAL INITIATE_APPROVAL
, PO_ERROR_MSG PO_ERROR_MSG
FROM "PON"."PON_BID_ITEM_PRICES"