DBA Data[Home] [Help] [Dependency Information]

VIEW: PON.PON_BID_ITEM_PRICES#

Object Details
Object Name: PON_BID_ITEM_PRICES#
Object Type: VIEW
Owner: PON
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUCTION_HEADER_ID NUMBER
Yes
AUCTION_LINE_NUMBER NUMBER
Yes
BID_NUMBER NUMBER
Yes
LINE_NUMBER NUMBER

ITEM_DESCRIPTION VARCHAR2 (2500)
CATEGORY_ID NUMBER

CATEGORY_NAME VARCHAR2 (250)
UOM VARCHAR2 (3)
QUANTITY NUMBER

PRICE NUMBER

MINIMUM_BID_PRICE NUMBER

PROMISED_DATE DATE

AWARD_STATUS VARCHAR2 (25)
AWARD_STATUS_NAME VARCHAR2 (80)
AWARD_DATE DATE

AWARD_QUANTITY NUMBER

ORDER_NUMBER VARCHAR2 (50)
NOTE_TO_AUCTION_OWNER VARCHAR2 (4000)
ATTACHMENTS_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

SHIP_TO_LOCATION_ID NUMBER

PUBLISH_DATE DATE

PROXY_BID_LIMIT_PRICE NUMBER

PROXY_BID_LIMIT_PRICE_DATE DATE

BID_CURRENCY_PRICE NUMBER

AUCTION_LINE_TYPE VARCHAR2 (10)
AUCTION_LOT_LINE_NUMBER NUMBER

LOT_LINE_NUMBER NUMBER

BID_CURRENCY_LIMIT_PRICE NUMBER

PROXY_BID_FLAG VARCHAR2 (1)
FIRST_BID_PRICE NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
HAS_ATTRIBUTES_FLAG VARCHAR2 (1)
BID_NUMBER_ORIGINAL_ROUND NUMBER

BID_NUMBER_PREV_ROUND NUMBER

COUNTER_PRICE_NUMBER NUMBER

FREIGHT_TERMS_CODE VARCHAR2 (30)
TBD_PRICING_FLAG VARCHAR2 (1)
AUC_TRADING_PARTNER_ID NUMBER

BID_TRADING_PARTNER_ID NUMBER

TOTAL_WEIGHTED_SCORE NUMBER

RANK NUMBER

TRIGGER_BID_NUMBER NUMBER

PO_MIN_REL_AMOUNT NUMBER

PO_BID_MIN_REL_AMOUNT NUMBER

PRICE_BREAK_TYPE VARCHAR2 (25)
HAS_SHIPMENTS_FLAG VARCHAR2 (1)
CANCELLED_LIMIT_PRICE NUMBER

IS_CHANGED_LINE_FLAG VARCHAR2 (240)
HAS_PRICE_DIFFERENTIALS_FLAG VARCHAR2 (1)
PRICE_DIFF_SHIPMENT_NUMBER NUMBER

BID_CURRENCY_TRANS_PRICE NUMBER

UNIT_PRICE NUMBER

BID_CURRENCY_UNIT_PRICE NUMBER

GROUP_AMOUNT NUMBER

HAS_BID_PAYMENTS_FLAG VARCHAR2 (1)
ADVANCE_AMOUNT NUMBER

BID_CURR_ADVANCE_AMOUNT NUMBER

RECOUPMENT_RATE_PERCENT NUMBER

PROGRESS_PYMT_RATE_PERCENT NUMBER

RETAINAGE_RATE_PERCENT NUMBER

MAX_RETAINAGE_AMOUNT NUMBER

BID_CURR_MAX_RETAINAGE_AMT NUMBER

OLD_NO_OF_PAYMENTS NUMBER

OLD_BID_CURR_ADVANCE_AMOUNT NUMBER

OLD_RECOUPMENT_RATE_PERCENT NUMBER

OLD_PROGRESS_PYMT_RATE_PERCENT NUMBER

OLD_RETAINAGE_RATE_PERCENT NUMBER

OLD_BID_CURR_MAX_RETAINAGE_AMT NUMBER

OLD_PRICE NUMBER

OLD_BID_CURRENCY_UNIT_PRICE NUMBER

OLD_BID_CURRENCY_PRICE NUMBER

OLD_BID_CURRENCY_LIMIT_PRICE NUMBER

OLD_PO_BID_MIN_REL_AMOUNT NUMBER

OLD_QUANTITY NUMBER

OLD_PUBLISH_DATE DATE

OLD_PROMISED_DATE DATE

OLD_NOTE_TO_AUCTION_OWNER VARCHAR2 (4000)
HAS_BID_FLAG VARCHAR2 (1)
DISPLAY_PRICE_FACTORS_FLAG VARCHAR2 (1)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

BATCH_ID NUMBER

INTERFACE_LINE_ID NUMBER

COPY_PRICE_FOR_PROXY_FLAG VARCHAR2 (1)
AWARD_PRICE NUMBER

AWARD_SHIPMENT_NUMBER NUMBER

HAS_QUANITITY_TIERS VARCHAR2 (1)
PER_UNIT_PRICE_COMPONENT NUMBER

FIXED_AMOUNT_COMPONENT NUMBER

BID_START_PRICE NUMBER

HAS_QUANTITY_TIERS VARCHAR2 (1)
WORKSHEET_NAME VARCHAR2 (80)
WORKSHEET_SEQUENCE_NUMBER NUMBER

APPROVAL_STATUS VARCHAR2 (240)
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_CONTRACT_TYPE VARCHAR2 (100)
CLM_IDC_TYPE VARCHAR2 (100)
CLM_COST_CONSTRAINT VARCHAR2 (100)
IDV_LINE_ID NUMBER

PROMISE_POP_START_DATE DATE

PROMISE_POP_END_DATE DATE

LINE_TYPE_ID NUMBER

ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
PURCHASE_BASIS VARCHAR2 (25)
CLM_AMOUNT NUMBER

CLM_DELIVERY_EVENT_CODE VARCHAR2 (30)
CLM_PROMISE_PERIOD NUMBER

CLM_PROMISE_PERIOD_UOM VARCHAR2 (25)
CLM_PROMISE_POP_DURATION NUMBER

CLM_PROMISE_POP_DURATION_UOM VARCHAR2 (25)
HAS_USER_BID_FLAG VARCHAR2 (1)
USER_MARKED_FLAG VARCHAR2 (1)
IS_REBID_ON_LINE_FLAG VARCHAR2 (1)
PO_TXN_FLAG VARCHAR2 (1)
PO_HEADER_ID NUMBER

PO_WF_CREATION_RND NUMBER

PO_ERROR_CODE NUMBER

PO_START_DATE DATE

PO_END_DATE DATE

INITIATE_APPROVAL VARCHAR2 (25)
PO_ERROR_MSG VARCHAR2 (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

PON.PON_BID_ITEM_PRICES# references the following:

SchemaPON
TablePON_BID_ITEM_PRICES
PON.PON_BID_ITEM_PRICES# is referenced by following:

SchemaAPPS
SynonymPON_BID_ITEM_PRICES