[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_ITEM_PRICES_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | PON |
| Subobject Name: | |
| Status: | VALID |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, AWARD_STATUS
, LINE_NUMBER
, ITEM_DESCRIPTION
, CATEGORY_ID
, CATEGORY_NAME
, UOM_CODE
, QUANTITY
, NEED_BY_DATE
, SHIP_TO_LOCATION_ID
, NUMBER_OF_BIDS
, LOWEST_BID_PRICE
, LOWEST_BID_QUANTITY
, LOWEST_BID_PROMISED_DATE
, LOWEST_BID_NUMBER
, CLOSEST_PROMISED_DATE
, CLOSEST_BID_PRICE
, CLOSEST_BID_QUANTITY
, CLOSEST_BID_NUMBER
, TARGET_PRICE
, THRESHOLD_PRICE
, BID_START_PRICE
, NOTE_TO_BIDDERS
, ATTACHMENT_FLAG
, LANGUAGE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, AUCTION_CREATION_DATE
, CLOSE_BIDDING_DATE
, NUMBER_OF_EXTENSIONS
, RESERVE_PRICE
, DISPLAY_TARGET_PRICE_FLAG
, CURRENT_PRICE
, BEST_BID_PRICE
, BEST_BID_QUANTITY
, BEST_BID_PROMISED_DATE
, BEST_BID_NUMBER
, TYPE
, LOT_LINE_NUMBER
, MIN_BID_INCREMENT
, MIN_BID_DECREMENT
, BEST_BID_PROXY_LIMIT_PRICE
, BEST_BID_CURRENCY_PRICE
, BEST_BID_CURRENCY_CODE
, PO_MIN_REL_AMOUNT
, BEST_BID_FIRST_BID_PRICE
, UNIT_OF_MEASURE
, HAS_ATTRIBUTES_FLAG
, TRANSPORTATION_ORIGIN
, TRANSPORTATION_DEST
, AUCTION_HEADER_ID_ORIG_ROUND
, AUCTION_HEADER_ID_PREV_ROUND
, LINE_NUMBER_ORIGINAL_ROUND
, LINE_NUMBER_PREV_ROUND
, MULTIPLE_PRICES_FLAG
, RESIDUAL_QUANTITY
, PENDING_QUANTITY
, CANCEL_QUANTITY
, NUMBER_OF_COMMITMENTS
, NUMBER_OF_PENDING_COMMITMENTS
, TBD_PRICING_FLAG
, NEED_BY_START_DATE
, PRICE
, FREIGHT_TERMS_CODE
, 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
, ORG_ID
, HAS_PRICE_ELEMENTS_FLAG
, LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE
, LINE_ORIGINATION_CODE
, REQUISITION_NUMBER
, ITEM_REVISION
, ITEM_ID
, ITEM_NUMBER
, 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
, IS_QUANTITY_SCORED
, IS_NEED_BY_DATE_SCORED
, 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
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BATCH_ID
, INTERFACE_LINE_ID
, IP_CATEGORY_ID
, HAS_QUANTITY_TIERS
, CLM_BASE_LINE_NUM
, CLM_FUNDED_FLAG
, CLM_INFO_FLAG
, CLM_OPTION_FROM_DATE
, CLM_OPTION_INDICATOR
, CLM_OPTION_NUM
, CLM_OPTION_TO_DATE
, GROUP_LINE_ID
, LINE_NUM_DISPLAY
, UDA_TEMPLATE_ID
, CLM_UNIT_PRICE
, CLM_CONTRACT_TYPE
, CLM_COST_CONSTRAINT
, CLM_IDC_TYPE
, CLM_AMOUNT
, CLM_NEED_BY_DATE
, EXHIBIT_NUMBER
, CLM_DELIVERY_EVENT_CODE
, CLM_DELIVERY_PERIOD
, CLM_DELIVERY_PERIOD_UOM
, CLM_POP_DURATION
, CLM_POP_DURATION_UOM
FROM PON.PON_AUCTION_ITEM_PRICES_ALL#;
PON
PON_AUCTION_ITEM_PRICES_ALL
APPS
PON_AUCTION_ITEM_PRICES
PON_AUCTION_ITEM_PRICES_ALL
|
|
|
|