[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_ITEM_PRICES_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | PON |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | Yes | ||
| AWARD_STATUS | VARCHAR2 | (25) | ||
| LINE_NUMBER | NUMBER | Yes | ||
| ITEM_DESCRIPTION | VARCHAR2 | (2500) | ||
| CATEGORY_ID | NUMBER | |||
| CATEGORY_NAME | VARCHAR2 | (250) | ||
| UOM_CODE | VARCHAR2 | (3) | ||
| QUANTITY | NUMBER | |||
| NEED_BY_DATE | DATE | |||
| SHIP_TO_LOCATION_ID | NUMBER | |||
| NUMBER_OF_BIDS | NUMBER | |||
| LOWEST_BID_PRICE | NUMBER | |||
| LOWEST_BID_QUANTITY | NUMBER | |||
| LOWEST_BID_PROMISED_DATE | DATE | |||
| LOWEST_BID_NUMBER | NUMBER | |||
| CLOSEST_PROMISED_DATE | DATE | |||
| CLOSEST_BID_PRICE | NUMBER | |||
| CLOSEST_BID_QUANTITY | NUMBER | |||
| CLOSEST_BID_NUMBER | NUMBER | |||
| TARGET_PRICE | NUMBER | |||
| THRESHOLD_PRICE | NUMBER | |||
| BID_START_PRICE | NUMBER | |||
| NOTE_TO_BIDDERS | VARCHAR2 | (4000) | ||
| ATTACHMENT_FLAG | VARCHAR2 | (1) | ||
| LANGUAGE_CODE | VARCHAR2 | (4) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| AUCTION_CREATION_DATE | DATE | |||
| CLOSE_BIDDING_DATE | DATE | |||
| NUMBER_OF_EXTENSIONS | NUMBER | |||
| RESERVE_PRICE | NUMBER | |||
| DISPLAY_TARGET_PRICE_FLAG | VARCHAR2 | (1) | ||
| CURRENT_PRICE | NUMBER | |||
| BEST_BID_PRICE | NUMBER | |||
| BEST_BID_QUANTITY | NUMBER | |||
| BEST_BID_PROMISED_DATE | DATE | |||
| BEST_BID_NUMBER | NUMBER | |||
| TYPE | VARCHAR2 | (10) | ||
| LOT_LINE_NUMBER | NUMBER | |||
| MIN_BID_INCREMENT | NUMBER | |||
| MIN_BID_DECREMENT | NUMBER | |||
| BEST_BID_PROXY_LIMIT_PRICE | NUMBER | |||
| BEST_BID_CURRENCY_PRICE | NUMBER | |||
| BEST_BID_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PO_MIN_REL_AMOUNT | NUMBER | |||
| BEST_BID_FIRST_BID_PRICE | NUMBER | |||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| HAS_ATTRIBUTES_FLAG | VARCHAR2 | (1) | ||
| TRANSPORTATION_ORIGIN | VARCHAR2 | (240) | ||
| TRANSPORTATION_DEST | VARCHAR2 | (240) | ||
| AUCTION_HEADER_ID_ORIG_ROUND | NUMBER | |||
| AUCTION_HEADER_ID_PREV_ROUND | NUMBER | |||
| LINE_NUMBER_ORIGINAL_ROUND | NUMBER | |||
| LINE_NUMBER_PREV_ROUND | NUMBER | |||
| MULTIPLE_PRICES_FLAG | VARCHAR2 | (1) | ||
| RESIDUAL_QUANTITY | NUMBER | |||
| PENDING_QUANTITY | NUMBER | |||
| CANCEL_QUANTITY | NUMBER | |||
| NUMBER_OF_COMMITMENTS | NUMBER | |||
| NUMBER_OF_PENDING_COMMITMENTS | NUMBER | |||
| TBD_PRICING_FLAG | VARCHAR2 | (1) | ||
| NEED_BY_START_DATE | DATE | |||
| PRICE | NUMBER | |||
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
| AWARDED_QUANTITY | NUMBER | |||
| MODIFIED_FLAG | VARCHAR2 | (1) | ||
| BEST_BID_BID_PRICE | NUMBER | |||
| BEST_BID_SCORE | NUMBER | |||
| BEST_BID_BID_NUMBER | NUMBER | |||
| BEST_BID_BID_CURRENCY_PRICE | NUMBER | |||
| BEST_BID_BID_CURRENCY_CODE | VARCHAR2 | (15) | ||
| ORG_ID | NUMBER | |||
| HAS_PRICE_ELEMENTS_FLAG | VARCHAR2 | (240) | ||
| LINE_TYPE_ID | NUMBER | |||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
| LINE_ORIGINATION_CODE | VARCHAR2 | (50) | ||
| REQUISITION_NUMBER | VARCHAR2 | (20) | ||
| ITEM_REVISION | VARCHAR2 | (3) | ||
| ITEM_ID | NUMBER | |||
| ITEM_NUMBER | VARCHAR2 | (820) | ||
| PRICE_BREAK_TYPE | VARCHAR2 | (25) | ||
| PRICE_BREAK_NEG_FLAG | VARCHAR2 | (1) | ||
| HAS_SHIPMENTS_FLAG | VARCHAR2 | (1) | ||
| SOURCE_DOC_NUMBER | VARCHAR2 | (20) | ||
| SOURCE_LINE_NUMBER | VARCHAR2 | (20) | ||
| SOURCE_DOC_ID | NUMBER | |||
| SOURCE_LINE_ID | NUMBER | |||
| ALLOCATION_STATUS | VARCHAR2 | (30) | ||
| PRICE_DISABLED_FLAG | VARCHAR2 | (1) | ||
| QUANTITY_DISABLED_FLAG | VARCHAR2 | (1) | ||
| JOB_ID | NUMBER | |||
| ADDITIONAL_JOB_DETAILS | VARCHAR2 | (2000) | ||
| PO_AGREED_AMOUNT | NUMBER | |||
| HAS_PRICE_DIFFERENTIALS_FLAG | VARCHAR2 | (1) | ||
| DIFFERENTIAL_RESPONSE_TYPE | VARCHAR2 | (20) | ||
| PURCHASE_BASIS | VARCHAR2 | (25) | ||
| IS_QUANTITY_SCORED | VARCHAR2 | (1) | ||
| IS_NEED_BY_DATE_SCORED | VARCHAR2 | (1) | ||
| DISP_LINE_NUMBER | NUMBER | |||
| LAST_UPDATE_LOGIN | NUMBER | |||
| LAST_AMENDMENT_UPDATE | NUMBER | |||
| MODIFIED_DATE | DATE | |||
| PRICE_DIFF_SHIPMENT_NUMBER | NUMBER | |||
| HAS_BUYER_PFS_FLAG | VARCHAR2 | (1) | ||
| UNIT_TARGET_PRICE | NUMBER | |||
| UNIT_DISPLAY_TARGET_FLAG | VARCHAR2 | (1) | ||
| GROUP_TYPE | VARCHAR2 | (25) | ||
| PARENT_LINE_NUMBER | NUMBER | |||
| DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | (25) | ||
| MAX_SUB_LINE_SEQUENCE_NUMBER | NUMBER | |||
| SUB_LINE_SEQUENCE_NUMBER | NUMBER | |||
| AWARD_MODE | VARCHAR2 | (30) | ||
| HAS_PAYMENTS_FLAG | VARCHAR2 | (1) | ||
| ADVANCE_AMOUNT | NUMBER | |||
| RECOUPMENT_RATE_PERCENT | NUMBER | |||
| PROGRESS_PYMT_RATE_PERCENT | NUMBER | |||
| RETAINAGE_RATE_PERCENT | NUMBER | |||
| MAX_RETAINAGE_AMOUNT | NUMBER | |||
| WORK_APPROVER_USER_ID | NUMBER | |||
| PROJECT_ID | NUMBER | |||
| PROJECT_TASK_ID | NUMBER | |||
| PROJECT_AWARD_ID | NUMBER | |||
| PROJECT_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| PROJECT_EXP_ORGANIZATION_ID | NUMBER | |||
| PROJECT_EXPENDITURE_ITEM_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| BATCH_ID | NUMBER | |||
| INTERFACE_LINE_ID | NUMBER | |||
| IP_CATEGORY_ID | NUMBER | |||
| HAS_QUANTITY_TIERS | VARCHAR2 | (1) | ||
| CLM_BASE_LINE_NUM | NUMBER | |||
| CLM_FUNDED_FLAG | VARCHAR2 | (1) | ||
| CLM_INFO_FLAG | VARCHAR2 | (1) | ||
| CLM_OPTION_FROM_DATE | DATE | |||
| CLM_OPTION_INDICATOR | VARCHAR2 | (1) | ||
| CLM_OPTION_NUM | NUMBER | |||
| CLM_OPTION_TO_DATE | DATE | |||
| GROUP_LINE_ID | NUMBER | |||
| LINE_NUM_DISPLAY | VARCHAR2 | (100) | ||
| UDA_TEMPLATE_ID | NUMBER | |||
| CLM_UNIT_PRICE | NUMBER | |||
| CLM_CONTRACT_TYPE | VARCHAR2 | (100) | ||
| CLM_COST_CONSTRAINT | VARCHAR2 | (100) | ||
| CLM_IDC_TYPE | VARCHAR2 | (100) | ||
| CLM_AMOUNT | NUMBER | |||
| CLM_NEED_BY_DATE | DATE | |||
| EXHIBIT_NUMBER | VARCHAR2 | (2) | ||
| CLM_DELIVERY_EVENT_CODE | VARCHAR2 | (30) | ||
| CLM_DELIVERY_PERIOD | NUMBER | |||
| CLM_DELIVERY_PERIOD_UOM | VARCHAR2 | (25) | ||
| CLM_POP_DURATION | NUMBER | |||
| CLM_POP_DURATION_UOM | VARCHAR2 | (25) |
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
|
|
|
|