[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#;
|
|
|