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_INTERFACE#

Source

View Text - Preformatted


select BATCH_ID BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, AUCTION_HEADER_ID AUCTION_HEADER_ID, BID_NUMBER BID_NUMBER, LINE_NUMBER LINE_NUMBER, QUANTITY QUANTITY, BID_CURRENCY_PRICE BID_CURRENCY_PRICE, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER, PROMISED_DATE PROMISED_DATE, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE, ATTACHMENT_DESC ATTACHMENT_DESC, ATTACHMENT_URL ATTACHMENT_URL, PO_BID_MIN_REL_AMOUNT PO_BID_MIN_REL_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, BID_CURR_MAX_RETAINAGE_AMT BID_CURR_MAX_RETAINAGE_AMT, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER, WORKSHEET_NAME WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER, PROMISE_POP_START_DATE PROMISE_POP_START_DATE, PROMISE_POP_END_DATE PROMISE_POP_END_DATE, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM, CLM_PROMISE_PERIOD_UOM_CODE CLM_PROMISE_PERIOD_UOM_CODE, CLM_PROMISE_POP_DURATION CLM_PROMISE_POP_DURATION, CLM_PROMISE_POP_DURATION_UOM CLM_PROMISE_POP_DURATION_UOM, CLM_PROMISE_POP_DUR_UOM_CODE CLM_PROMISE_POP_DUR_UOM_CODE from "PON"."PON_BID_ITEM_PRICES_INTERFACE"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, BID_NUMBER BID_NUMBER
, LINE_NUMBER LINE_NUMBER
, QUANTITY QUANTITY
, BID_CURRENCY_PRICE BID_CURRENCY_PRICE
, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER
, PROMISED_DATE PROMISED_DATE
, BID_CURRENCY_LIMIT_PRICE BID_CURRENCY_LIMIT_PRICE
, ATTACHMENT_DESC ATTACHMENT_DESC
, ATTACHMENT_URL ATTACHMENT_URL
, PO_BID_MIN_REL_AMOUNT PO_BID_MIN_REL_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
, BID_CURR_MAX_RETAINAGE_AMT BID_CURR_MAX_RETAINAGE_AMT
, DOCUMENT_DISP_LINE_NUMBER DOCUMENT_DISP_LINE_NUMBER
, WORKSHEET_NAME WORKSHEET_NAME
, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER
, PROMISE_POP_START_DATE PROMISE_POP_START_DATE
, PROMISE_POP_END_DATE PROMISE_POP_END_DATE
, CLM_PROMISE_PERIOD CLM_PROMISE_PERIOD
, CLM_PROMISE_PERIOD_UOM CLM_PROMISE_PERIOD_UOM
, CLM_PROMISE_PERIOD_UOM_CODE CLM_PROMISE_PERIOD_UOM_CODE
, CLM_PROMISE_POP_DURATION CLM_PROMISE_POP_DURATION
, CLM_PROMISE_POP_DURATION_UOM CLM_PROMISE_POP_DURATION_UOM
, CLM_PROMISE_POP_DUR_UOM_CODE CLM_PROMISE_POP_DUR_UOM_CODE
FROM "PON"."PON_BID_ITEM_PRICES_INTERFACE"