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

VIEW: PON.PON_BID_HEADERS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
BID_NUMBER NUMBER
Yes
AUCTION_HEADER_ID NUMBER
Yes
BIDDERS_BID_NUMBER VARCHAR2 (25)
BID_TYPE VARCHAR2 (25)
CONTRACT_TYPE VARCHAR2 (25)
TRADING_PARTNER_CONTACT_NAME VARCHAR2 (255)
TRADING_PARTNER_CONTACT_ID NUMBER

TRADING_PARTNER_NAME VARCHAR2 (255)
TRADING_PARTNER_ID NUMBER

PHONE VARCHAR2 (100)
FAX VARCHAR2 (100)
EMAIL VARCHAR2 (100)
BID_STATUS VARCHAR2 (25)
BID_STATUS_NAME VARCHAR2 (80)
AWARD_STATUS VARCHAR2 (25)
AWARD_STATUS_NAME VARCHAR2 (80)
BID_EFFECTIVE_DATE DATE

BID_EXPIRATION_DATE DATE

PUBLISH_DATE DATE

CANCELLED_DATE DATE

DISQUALIFY_REASON VARCHAR2 (240)
FREIGHT_TERMS_CODE VARCHAR2 (30)
CARRIER_CODE VARCHAR2 (25)
FOB_CODE VARCHAR2 (25)
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

BID_CURRENCY_CODE VARCHAR2 (15)
RATE NUMBER

RATE_TYPE VARCHAR2 (25)
RATE_DATE DATE

MIN_BID_CHANGE NUMBER

ORDER_NUMBER VARCHAR2 (50)
PO_TXN_FLAG VARCHAR2 (1)
DOCUMENT_TRACKING_ID NUMBER

PROXY_BID_FLAG VARCHAR2 (1)
NUMBER_PRICE_DECIMALS NUMBER

PO_AGREED_AMOUNT NUMBER

BID_NUMBER_ORIGINAL_ROUND NUMBER

BID_NUMBER_PREV_ROUND NUMBER

DOCTYPE_ID NUMBER

BID_REVISION_NUMBER NUMBER

ORIGINAL_BID_NUMBER NUMBER

ORIGINAL_REVISION_NUMBER NUMBER

CANCEL_REASON VARCHAR2 (240)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

AGENT_ID NUMBER

CREATE_SOURCING_RULES VARCHAR2 (1)
UPDATE_SOURCING_RULES VARCHAR2 (1)
RELEASE_METHOD VARCHAR2 (25)
PO_HEADER_ID NUMBER

PO_WF_CREATION_RND NUMBER

PAYMENT_TERMS_ID NUMBER

PO_ERROR_CODE NUMBER

RATE_DSP NUMBER

PO_START_DATE DATE

PO_END_DATE DATE

INITIATE_APPROVAL VARCHAR2 (25)
PO_ERROR_MSG VARCHAR2 (2000)
DRAFT_LOCKED VARCHAR2 (1)
DRAFT_LOCKED_BY NUMBER

DRAFT_LOCKED_BY_CONTACT_ID NUMBER

DRAFT_LOCKED_DATE DATE

DRAFT_UNLOCKED_BY NUMBER

DRAFT_UNLOCKED_BY_CONTACT_ID NUMBER

DRAFT_UNLOCKED_DATE DATE

VENDOR_SITE_CODE VARCHAR2 (15)
INTERNAL_NOTE VARCHAR2 (4000)
SHORTLIST_FLAG VARCHAR2 (1)
ATTRIBUTE_LINE_NUMBER NUMBER
Yes
NOTE_TO_SUPPLIER VARCHAR2 (4000)
TOTAL_AWARD_AMOUNT NUMBER

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
SURROG_BID_CREATED_TP_ID NUMBER

SURROG_BID_CREATED_CONTACT_ID NUMBER

SURROG_BID_RECEIPT_DATE DATE

SURROG_BID_ONLINE_ENTRY_DATE DATE

SURROG_BID_FLAG VARCHAR2 (1)
COLOR_SEQUENCE_ID NUMBER

AWARD_DATE DATE

PARTIAL_RESPONSE_FLAG VARCHAR2 (1)
INCUMBENT_FLAG VARCHAR2 (1)
SCORE_OVERRIDEN_FLAG VARCHAR2 (1)
SCORE_OVERRIDEN_DATE DATE

SCORE_OVERRIDE_TP_CONTACT_ID NUMBER

REQUEST_ID NUMBER

REQUEST_DATE DATE

REQUESTED_BY NUMBER

IMPORT_FILE_NAME VARCHAR2 (255)
REL12_DRAFT_FLAG VARCHAR2 (1)
OLD_NOTE_TO_AUCTION_OWNER VARCHAR2 (4000)
OLD_BIDDERS_BID_NUMBER VARCHAR2 (25)
OLD_BID_EXPIRATION_DATE DATE

OLD_BID_STATUS VARCHAR2 (25)
OLD_MIN_BID_CHANGE NUMBER

OLD_SURROG_BID_RECEIPT_DATE DATE

DISPLAY_PRICE_FACTORS_FLAG VARCHAR2 (1)
OLD_BID_NUMBER NUMBER

BUYER_BID_TOTAL NUMBER

SHORTLIST_TPC_ID NUMBER

CURRENT_TOTAL_SPEND NUMBER

FIXED_INCENTIVE NUMBER

CURRENT_REBATE NUMBER

HAS_REBATE_TIERS VARCHAR2 (1)
TECHNICAL_SHORTLIST_FLAG VARCHAR2 (1)
SUBMIT_STAGE VARCHAR2 (20)
EVALUATOR_ID NUMBER

EVALUATION_FLAG VARCHAR2 (1)
UDA_TEMPLATE_ID NUMBER

UDA_TEMPLATE_DATE DATE

EXTERNAL_IDV VARCHAR2 (240)
IDV_HEADER_ID NUMBER

WITHDRAW_REASON VARCHAR2 (240)
Query Text

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


SELECT BID_NUMBER
,      AUCTION_HEADER_ID
,      BIDDERS_BID_NUMBER
,      BID_TYPE
,      CONTRACT_TYPE
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      PHONE
,      FAX
,      EMAIL
,      BID_STATUS
,      BID_STATUS_NAME
,      AWARD_STATUS
,      AWARD_STATUS_NAME
,      BID_EFFECTIVE_DATE
,      BID_EXPIRATION_DATE
,      PUBLISH_DATE
,      CANCELLED_DATE
,      DISQUALIFY_REASON
,      FREIGHT_TERMS_CODE
,      CARRIER_CODE
,      FOB_CODE
,      NOTE_TO_AUCTION_OWNER
,      ATTACHMENTS_FLAG
,      LANGUAGE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      AUCTION_CREATION_DATE
,      BID_CURRENCY_CODE
,      RATE
,      RATE_TYPE
,      RATE_DATE
,      MIN_BID_CHANGE
,      ORDER_NUMBER
,      PO_TXN_FLAG
,      DOCUMENT_TRACKING_ID
,      PROXY_BID_FLAG
,      NUMBER_PRICE_DECIMALS
,      PO_AGREED_AMOUNT
,      BID_NUMBER_ORIGINAL_ROUND
,      BID_NUMBER_PREV_ROUND
,      DOCTYPE_ID
,      BID_REVISION_NUMBER
,      ORIGINAL_BID_NUMBER
,      ORIGINAL_REVISION_NUMBER
,      CANCEL_REASON
,      VENDOR_ID
,      VENDOR_SITE_ID
,      AGENT_ID
,      CREATE_SOURCING_RULES
,      UPDATE_SOURCING_RULES
,      RELEASE_METHOD
,      PO_HEADER_ID
,      PO_WF_CREATION_RND
,      PAYMENT_TERMS_ID
,      PO_ERROR_CODE
,      RATE_DSP
,      PO_START_DATE
,      PO_END_DATE
,      INITIATE_APPROVAL
,      PO_ERROR_MSG
,      DRAFT_LOCKED
,      DRAFT_LOCKED_BY
,      DRAFT_LOCKED_BY_CONTACT_ID
,      DRAFT_LOCKED_DATE
,      DRAFT_UNLOCKED_BY
,      DRAFT_UNLOCKED_BY_CONTACT_ID
,      DRAFT_UNLOCKED_DATE
,      VENDOR_SITE_CODE
,      INTERNAL_NOTE
,      SHORTLIST_FLAG
,      ATTRIBUTE_LINE_NUMBER
,      NOTE_TO_SUPPLIER
,      TOTAL_AWARD_AMOUNT
,      ACCEPTANCE_REQUIRED_FLAG
,      SURROG_BID_CREATED_TP_ID
,      SURROG_BID_CREATED_CONTACT_ID
,      SURROG_BID_RECEIPT_DATE
,      SURROG_BID_ONLINE_ENTRY_DATE
,      SURROG_BID_FLAG
,      COLOR_SEQUENCE_ID
,      AWARD_DATE
,      PARTIAL_RESPONSE_FLAG
,      INCUMBENT_FLAG
,      SCORE_OVERRIDEN_FLAG
,      SCORE_OVERRIDEN_DATE
,      SCORE_OVERRIDE_TP_CONTACT_ID
,      REQUEST_ID
,      REQUEST_DATE
,      REQUESTED_BY
,      IMPORT_FILE_NAME
,      REL12_DRAFT_FLAG
,      OLD_NOTE_TO_AUCTION_OWNER
,      OLD_BIDDERS_BID_NUMBER
,      OLD_BID_EXPIRATION_DATE
,      OLD_BID_STATUS
,      OLD_MIN_BID_CHANGE
,      OLD_SURROG_BID_RECEIPT_DATE
,      DISPLAY_PRICE_FACTORS_FLAG
,      OLD_BID_NUMBER
,      BUYER_BID_TOTAL
,      SHORTLIST_TPC_ID
,      CURRENT_TOTAL_SPEND
,      FIXED_INCENTIVE
,      CURRENT_REBATE
,      HAS_REBATE_TIERS
,      TECHNICAL_SHORTLIST_FLAG
,      SUBMIT_STAGE
,      EVALUATOR_ID
,      EVALUATION_FLAG
,      UDA_TEMPLATE_ID
,      UDA_TEMPLATE_DATE
,      EXTERNAL_IDV
,      IDV_HEADER_ID
,      WITHDRAW_REASON
FROM PON.PON_BID_HEADERS#;

Dependencies

[top of page]

PON.PON_BID_HEADERS# references the following:

SchemaPON
TablePON_BID_HEADERS
PON.PON_BID_HEADERS# is referenced by following:

SchemaAPPS
SynonymPON_BID_HEADERS