Skip to content

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

VIEW: PON.PON_AUCTION_HEADERS_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
AUCTION_HEADER_ID NUMBER
Yes
AUCTION_TITLE VARCHAR2 (80)
AUCTION_STATUS VARCHAR2 (25)
AUCTION_STATUS_NAME VARCHAR2 (80)
AWARD_STATUS VARCHAR2 (25)
AWARD_STATUS_NAME VARCHAR2 (80)
AUCTION_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_NAME_UPPER VARCHAR2 (255)
TRADING_PARTNER_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

BILL_TO_LOCATION_ID NUMBER

OPEN_BIDDING_DATE DATE

CLOSE_BIDDING_DATE DATE

ORIGINAL_CLOSE_BIDDING_DATE DATE

VIEW_BY_DATE DATE

AWARD_BY_DATE DATE

PUBLISH_DATE DATE

CLOSE_DATE DATE

CANCEL_DATE DATE

TIME_ZONE VARCHAR2 (25)
BID_VISIBILITY_CODE VARCHAR2 (25)
BID_LIST_TYPE VARCHAR2 (25)
BID_FREQUENCY_CODE VARCHAR2 (25)
BID_SCOPE_CODE VARCHAR2 (25)
AUTO_EXTEND_FLAG VARCHAR2 (1)
AUTO_EXTEND_NUMBER NUMBER

NUMBER_OF_EXTENSIONS NUMBER

NUMBER_OF_BIDS NUMBER

MIN_BID_DECREMENT NUMBER

PRICE_DRIVEN_AUCTION_FLAG VARCHAR2 (1)
PAYMENT_TERMS_ID NUMBER

FREIGHT_TERMS_CODE VARCHAR2 (30)
FOB_CODE VARCHAR2 (25)
CARRIER_CODE VARCHAR2 (25)
CURRENCY_CODE VARCHAR2 (15)
RATE_TYPE VARCHAR2 (25)
RATE_DATE DATE

RATE 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

WF_ITEM_KEY VARCHAR2 (240)
WF_ROLE_NAME VARCHAR2 (30)
AUTO_EXTEND_ALL_LINES_FLAG VARCHAR2 (1)
MIN_BID_INCREMENT NUMBER

ALLOW_OTHER_BID_CURRENCY_FLAG VARCHAR2 (1)
SHIPPING_TERMS_CODE VARCHAR2 (25)
SHIPPING_TERMS VARCHAR2 (80)
AUTO_EXTEND_DURATION NUMBER

PROXY_BID_ALLOWED_FLAG VARCHAR2 (1)
PUBLISH_RATES_TO_BIDDERS_FLAG VARCHAR2 (1)
ATTRIBUTES_EXIST VARCHAR2 (20)
ORDER_NUMBER VARCHAR2 (20)
DOCUMENT_TRACKING_ID NUMBER

PO_TXN_FLAG VARCHAR2 (1)
EVENT_ID NUMBER

EVENT_TITLE VARCHAR2 (80)
SEALED_AUCTION_STATUS VARCHAR2 (30)
SEALED_ACTUAL_UNLOCK_DATE DATE

SEALED_ACTUAL_UNSEAL_DATE DATE

SEALED_UNLOCK_TP_CONTACT_ID NUMBER

SEALED_UNSEAL_TP_CONTACT_ID NUMBER

MODE_OF_TRANSPORT VARCHAR2 (80)
MODE_OF_TRANSPORT_CODE VARCHAR2 (25)
PO_START_DATE DATE

PO_END_DATE DATE

PO_AGREED_AMOUNT NUMBER

MIN_BID_CHANGE_TYPE VARCHAR2 (25)
FULL_QUANTITY_BID_CODE VARCHAR2 (25)
NUMBER_PRICE_DECIMALS NUMBER

AUTO_EXTEND_TYPE_FLAG VARCHAR2 (25)
AUCTION_ORIGINATION_CODE VARCHAR2 (50)
MULTIPLE_ROUNDS_FLAG VARCHAR2 (1)
AUCTION_HEADER_ID_ORIG_ROUND NUMBER

AUCTION_HEADER_ID_PREV_ROUND NUMBER

AUCTION_ROUND_NUMBER NUMBER

MANUAL_CLOSE_FLAG VARCHAR2 (1)
MANUAL_EXTEND_FLAG VARCHAR2 (1)
AUTOEXTEND_CHANGED_FLAG VARCHAR2 (1)
DOCTYPE_ID NUMBER

OFFER_TYPE VARCHAR2 (30)
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
MAX_RESPONSES NUMBER

RESPONSE_ALLOWED_FLAG VARCHAR2 (1)
FOB_NEG_FLAG VARCHAR2 (1)
CARRIER_NEG_FLAG VARCHAR2 (1)
FREIGHT_TERMS_NEG_FLAG VARCHAR2 (1)
MAX_RESPONSE_ITERATIONS NUMBER

PAYMENT_TERMS_NEG_FLAG VARCHAR2 (1)
MODE_OF_TRANSPORT_NEG_FLAG VARCHAR2 (1)
CONTRACT_ID NUMBER

CONTRACT_VERSION_NUM NUMBER

SHIPPING_TERMS_NEG_FLAG VARCHAR2 (1)
SHIPPING_METHOD_NEG_FLAG VARCHAR2 (1)
USE_REGIONAL_PRICING_FLAG VARCHAR2 (1)
SHOW_BIDDER_NOTES VARCHAR2 (1)
DERIVE_TYPE VARCHAR2 (8)
PRE_DELETE_AUCTION_STATUS VARCHAR2 (25)
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

MAX_LINE_NUMBER NUMBER

BID_RANKING VARCHAR2 (25)
RANK_INDICATOR VARCHAR2 (25)
SHOW_BIDDER_SCORES VARCHAR2 (25)
OPEN_AUCTION_NOW_FLAG VARCHAR2 (1)
PUBLISH_AUCTION_NOW_FLAG VARCHAR2 (1)
TEMPLATE_ID NUMBER

REMINDER_DATE DATE

ORG_ID NUMBER

BUYER_ID NUMBER

MANUAL_EDIT_FLAG VARCHAR2 (1)
WF_PONCOMPL_ITEM_KEY VARCHAR2 (240)
HAS_PE_FOR_ALL_ITEMS VARCHAR2 (30)
HAS_PRICE_ELEMENTS VARCHAR2 (30)
PO_MIN_REL_AMOUNT NUMBER

GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
OUTCOME_STATUS VARCHAR2 (30)
SOURCE_REQS_FLAG VARCHAR2 (25)
AWARD_COMPLETE_DATE DATE

WF_PONCOMPL_CURRENT_ROUND NUMBER

SECURITY_LEVEL_CODE VARCHAR2 (25)
WF_APPROVAL_ITEM_KEY VARCHAR2 (240)
APPROVAL_STATUS VARCHAR2 (30)
SOURCE_DOC_ID NUMBER

SOURCE_DOC_NUMBER VARCHAR2 (20)
SOURCE_DOC_MSG VARCHAR2 (30)
SOURCE_DOC_LINE_MSG VARCHAR2 (30)
SOURCE_DOC_MSG_APP VARCHAR2 (3)
SHARE_AWARD_DECISION VARCHAR2 (1)
DESCRIPTION VARCHAR2 (250)
TEMPLATE_SCOPE VARCHAR2 (25)
TEMPLATE_STATUS VARCHAR2 (25)
IS_TEMPLATE_FLAG VARCHAR2 (1)
AWARD_APPROVAL_FLAG VARCHAR2 (1)
AWARD_APPROVAL_STATUS VARCHAR2 (30)
AWARD_APPR_AME_TRANS_ID VARCHAR2 (80)
AWARD_APPR_AME_TRANS_PREV_ID VARCHAR2 (80)
WF_AWARD_APPROVAL_ITEM_KEY VARCHAR2 (240)
AMENDMENT_NUMBER NUMBER

AMENDMENT_DESCRIPTION VARCHAR2 (4000)
AUCTION_HEADER_ID_ORIG_AMEND NUMBER

AUCTION_HEADER_ID_PREV_AMEND NUMBER

DOCUMENT_NUMBER VARCHAR2 (240)
AWARD_APPR_AME_TXN_DATE DATE

HDR_ATTR_ENABLE_WEIGHTS VARCHAR2 (1)
HDR_ATTR_DISPLAY_SCORE VARCHAR2 (1)
HDR_ATTR_MAXIMUM_SCORE NUMBER

ATTRIBUTE_LINE_NUMBER NUMBER
Yes
CONTERMS_EXIST_FLAG VARCHAR2 (1)
CONTERMS_ARTICLES_UPD_DATE DATE

CONTERMS_DELIV_UPD_DATE DATE

AWARD_MODE VARCHAR2 (30)
HAS_HDR_ATTR_FLAG VARCHAR2 (1)
AWARD_DATE DATE

MAX_INTERNAL_LINE_NUM NUMBER

MAX_BID_COLOR_SEQUENCE_ID NUMBER

HAS_ITEMS_FLAG VARCHAR2 (1)
INT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
INT_ATTRIBUTE1 VARCHAR2 (150)
INT_ATTRIBUTE2 VARCHAR2 (150)
INT_ATTRIBUTE3 VARCHAR2 (150)
INT_ATTRIBUTE4 VARCHAR2 (150)
INT_ATTRIBUTE5 VARCHAR2 (150)
INT_ATTRIBUTE6 VARCHAR2 (150)
INT_ATTRIBUTE7 VARCHAR2 (150)
INT_ATTRIBUTE8 VARCHAR2 (150)
INT_ATTRIBUTE9 VARCHAR2 (150)
INT_ATTRIBUTE10 VARCHAR2 (150)
INT_ATTRIBUTE11 VARCHAR2 (150)
INT_ATTRIBUTE12 VARCHAR2 (150)
INT_ATTRIBUTE13 VARCHAR2 (150)
INT_ATTRIBUTE14 VARCHAR2 (150)
INT_ATTRIBUTE15 VARCHAR2 (150)
EXT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
EXT_ATTRIBUTE1 VARCHAR2 (150)
EXT_ATTRIBUTE2 VARCHAR2 (150)
EXT_ATTRIBUTE3 VARCHAR2 (150)
EXT_ATTRIBUTE4 VARCHAR2 (150)
EXT_ATTRIBUTE5 VARCHAR2 (150)
EXT_ATTRIBUTE6 VARCHAR2 (150)
EXT_ATTRIBUTE7 VARCHAR2 (150)
EXT_ATTRIBUTE8 VARCHAR2 (150)
EXT_ATTRIBUTE9 VARCHAR2 (150)
EXT_ATTRIBUTE10 VARCHAR2 (150)
EXT_ATTRIBUTE11 VARCHAR2 (150)
EXT_ATTRIBUTE12 VARCHAR2 (150)
EXT_ATTRIBUTE13 VARCHAR2 (150)
EXT_ATTRIBUTE14 VARCHAR2 (150)
EXT_ATTRIBUTE15 VARCHAR2 (150)
INCLUDE_PDF_IN_EXTERNAL_PAGE VARCHAR2 (1)
ABSTRACT_DETAILS VARCHAR2 (4000)
ABSTRACT_STATUS VARCHAR2 (20)
PF_TYPE_ALLOWED VARCHAR2 (30)
SUPPLIER_VIEW_TYPE VARCHAR2 (30)
IS_PAUSED VARCHAR2 (1)
PAUSE_REMARKS VARCHAR2 (2000)
LAST_PAUSE_DATE DATE

MAX_DOCUMENT_LINE_NUM NUMBER

PROGRESS_PAYMENT_TYPE VARCHAR2 (10)
ADVANCE_NEGOTIABLE_FLAG VARCHAR2 (1)
RECOUPMENT_NEGOTIABLE_FLAG VARCHAR2 (1)
PROGRESS_PYMT_NEGOTIABLE_FLAG VARCHAR2 (1)
RETAINAGE_NEGOTIABLE_FLAG VARCHAR2 (1)
MAX_RETAINAGE_NEGOTIABLE_FLAG VARCHAR2 (1)
SUPPLIER_ENTERABLE_PYMT_FLAG VARCHAR2 (1)
PROJECT_ID NUMBER

TEAM_SCORING_ENABLED_FLAG VARCHAR2 (1)
HAS_SCORING_TEAMS_FLAG VARCHAR2 (1)
SCORING_LOCK_DATE DATE

SCORING_LOCK_TP_CONTACT_ID NUMBER

REQUEST_ID NUMBER

REQUEST_DATE DATE

REQUESTED_BY NUMBER

IMPORT_FILE_NAME VARCHAR2 (255)
NUMBER_OF_LINES NUMBER

LAST_LINE_NUMBER NUMBER

STYLE_ID NUMBER

LINE_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
LINE_MAS_ENABLED_FLAG VARCHAR2 (1)
PRICE_ELEMENT_ENABLED_FLAG VARCHAR2 (1)
RFI_LINE_ENABLED_FLAG VARCHAR2 (1)
LOT_ENABLED_FLAG VARCHAR2 (1)
GROUP_ENABLED_FLAG VARCHAR2 (1)
LARGE_NEG_ENABLED_FLAG VARCHAR2 (1)
HDR_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
NEG_TEAM_ENABLED_FLAG VARCHAR2 (1)
PROXY_BIDDING_ENABLED_FLAG VARCHAR2 (1)
POWER_BIDDING_ENABLED_FLAG VARCHAR2 (1)
AUTO_EXTEND_ENABLED_FLAG VARCHAR2 (1)
PO_STYLE_ID NUMBER

PRICE_BREAK_RESPONSE VARCHAR2 (25)
GLOBAL_TEMPLATE_FLAG VARCHAR2 (1)
CONTRACT_TEMPLATE_ID NUMBER

COMPLETE_FLAG VARCHAR2 (1)
BID_DECREMENT_METHOD VARCHAR2 (15)
DISPLAY_BEST_PRICE_BLIND_FLAG VARCHAR2 (1)
FIRST_LINE_CLOSE_DATE DATE

STAGGERED_CLOSING_INTERVAL NUMBER

ENFORCE_PREVRND_BID_PRICE_FLAG VARCHAR2 (1)
PRICE_TIERS_INDICATOR VARCHAR2 (30)
AUTO_EXTEND_MIN_TRIGGER_RANK NUMBER

QTY_PRICE_TIERS_ENABLED_FLAG VARCHAR2 (1)
TWO_PART_FLAG VARCHAR2 (1)
TECHNICAL_LOCK_STATUS VARCHAR2 (20)
TECHNICAL_EVALUATION_STATUS VARCHAR2 (20)
TECHNICAL_ACTUAL_UNLOCK_DATE DATE

TECHNICAL_ACTUAL_UNSEAL_DATE DATE

TECHNICAL_UNLOCK_TP_CONTACT_ID NUMBER

TECHNICAL_UNSEAL_TP_CONTACT_ID NUMBER

NO_OF_NOTIFICATIONS_SENT NUMBER

EMD_ENABLE_FLAG VARCHAR2 (1)
EMD_AMOUNT NUMBER

EMD_DUE_DATE DATE

EMD_TYPE VARCHAR2 (30)
EMD_GUARANTEE_EXPIRY_DATE NUMBER

EMD_ADDITIONAL_INFORMATION VARCHAR2 (2000)
POST_EMD_TO_FINANCE VARCHAR2 (1)
NEGOTIATION_REQUESTER_ID NUMBER

SUPP_REG_QUAL_FLAG VARCHAR2 (1)
SUPP_EVAL_FLAG VARCHAR2 (1)
HIDE_TERMS_FLAG VARCHAR2 (1)
HIDE_ABSTRACT_FORMS_FLAG VARCHAR2 (1)
HIDE_ATTACHMENTS_FLAG VARCHAR2 (1)
INTERNAL_EVAL_FLAG VARCHAR2 (1)
HDR_SUPP_ATTR_ENABLED_FLAG VARCHAR2 (1)
INTGR_HDR_ATTR_FLAG VARCHAR2 (1)
INTGR_HDR_ATTACH_FLAG VARCHAR2 (1)
LINE_SUPP_ATTR_ENABLED_FLAG VARCHAR2 (1)
ITEM_SUPP_ATTR_ENABLED_FLAG VARCHAR2 (1)
INTGR_CAT_LINE_ATTR_FLAG VARCHAR2 (1)
INTGR_ITEM_LINE_ATTR_FLAG VARCHAR2 (1)
INTGR_CAT_LINE_ASL_FLAG VARCHAR2 (1)
INTERNAL_ONLY_FLAG VARCHAR2 (1)
SYNC_STATUS VARCHAR2 (25)
REVISION NUMBER

AMENDMENT_FLAG VARCHAR2 (1)
CANCEL_AMENDMENT VARCHAR2 (1)
EFFECTIVE_DATE DATE

SIGNED_DATE DATE

UDA_TEMPLATE_ID NUMBER

UDA_TEMPLATE_DATE DATE

SOLICITATION_TYPE VARCHAR2 (10)
NO_OF_COPIES NUMBER

CD_GENERATED_DATE DATE

CD_EDITBYUSER_FLAG VARCHAR2 (1)
CD_GENERATED_FLAG VARCHAR2 (1)
AMENDUPDATED_AFTERCDGENERATED VARCHAR2 (1)
CHANGEDESCRIPTION_DATA CLOB (4000)
CONCURRENT_REQID VARCHAR2 (20)
STANDARD_FORM VARCHAR2 (240)
DOCUMENT_FORMAT VARCHAR2 (240)
FEDERAL_PUBLICATION_EXCEPTION VARCHAR2 (30)
UMBRELLA_PROGRAM_ID NUMBER

FAIR_OPP_NOTICE_FLAG VARCHAR2 (1)
ALLOW_WITHDRAW_FLAG VARCHAR2 (1)
ALLOW_UNSOL_OFFER_LINES VARCHAR2 (1)
ALLOW_MULTIPLE_ACTIVE_OFFERS VARCHAR2 (1)
ALLOW_STAGGERED_AWARDS VARCHAR2 (1)
Query Text

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


SELECT AUCTION_HEADER_ID
,      AUCTION_TITLE
,      AUCTION_STATUS
,      AUCTION_STATUS_NAME
,      AWARD_STATUS
,      AWARD_STATUS_NAME
,      AUCTION_TYPE
,      CONTRACT_TYPE
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_NAME_UPPER
,      TRADING_PARTNER_ID
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      OPEN_BIDDING_DATE
,      CLOSE_BIDDING_DATE
,      ORIGINAL_CLOSE_BIDDING_DATE
,      VIEW_BY_DATE
,      AWARD_BY_DATE
,      PUBLISH_DATE
,      CLOSE_DATE
,      CANCEL_DATE
,      TIME_ZONE
,      BID_VISIBILITY_CODE
,      BID_LIST_TYPE
,      BID_FREQUENCY_CODE
,      BID_SCOPE_CODE
,      AUTO_EXTEND_FLAG
,      AUTO_EXTEND_NUMBER
,      NUMBER_OF_EXTENSIONS
,      NUMBER_OF_BIDS
,      MIN_BID_DECREMENT
,      PRICE_DRIVEN_AUCTION_FLAG
,      PAYMENT_TERMS_ID
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      CARRIER_CODE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      NOTE_TO_BIDDERS
,      ATTACHMENT_FLAG
,      LANGUAGE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      WF_ITEM_KEY
,      WF_ROLE_NAME
,      AUTO_EXTEND_ALL_LINES_FLAG
,      MIN_BID_INCREMENT
,      ALLOW_OTHER_BID_CURRENCY_FLAG
,      SHIPPING_TERMS_CODE
,      SHIPPING_TERMS
,      AUTO_EXTEND_DURATION
,      PROXY_BID_ALLOWED_FLAG
,      PUBLISH_RATES_TO_BIDDERS_FLAG
,      ATTRIBUTES_EXIST
,      ORDER_NUMBER
,      DOCUMENT_TRACKING_ID
,      PO_TXN_FLAG
,      EVENT_ID
,      EVENT_TITLE
,      SEALED_AUCTION_STATUS
,      SEALED_ACTUAL_UNLOCK_DATE
,      SEALED_ACTUAL_UNSEAL_DATE
,      SEALED_UNLOCK_TP_CONTACT_ID
,      SEALED_UNSEAL_TP_CONTACT_ID
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_CODE
,      PO_START_DATE
,      PO_END_DATE
,      PO_AGREED_AMOUNT
,      MIN_BID_CHANGE_TYPE
,      FULL_QUANTITY_BID_CODE
,      NUMBER_PRICE_DECIMALS
,      AUTO_EXTEND_TYPE_FLAG
,      AUCTION_ORIGINATION_CODE
,      MULTIPLE_ROUNDS_FLAG
,      AUCTION_HEADER_ID_ORIG_ROUND
,      AUCTION_HEADER_ID_PREV_ROUND
,      AUCTION_ROUND_NUMBER
,      MANUAL_CLOSE_FLAG
,      MANUAL_EXTEND_FLAG
,      AUTOEXTEND_CHANGED_FLAG
,      DOCTYPE_ID
,      OFFER_TYPE
,      APPROVAL_REQUIRED_FLAG
,      MAX_RESPONSES
,      RESPONSE_ALLOWED_FLAG
,      FOB_NEG_FLAG
,      CARRIER_NEG_FLAG
,      FREIGHT_TERMS_NEG_FLAG
,      MAX_RESPONSE_ITERATIONS
,      PAYMENT_TERMS_NEG_FLAG
,      MODE_OF_TRANSPORT_NEG_FLAG
,      CONTRACT_ID
,      CONTRACT_VERSION_NUM
,      SHIPPING_TERMS_NEG_FLAG
,      SHIPPING_METHOD_NEG_FLAG
,      USE_REGIONAL_PRICING_FLAG
,      SHOW_BIDDER_NOTES
,      DERIVE_TYPE
,      PRE_DELETE_AUCTION_STATUS
,      DRAFT_LOCKED
,      DRAFT_LOCKED_BY
,      DRAFT_LOCKED_BY_CONTACT_ID
,      DRAFT_LOCKED_DATE
,      DRAFT_UNLOCKED_BY
,      DRAFT_UNLOCKED_BY_CONTACT_ID
,      DRAFT_UNLOCKED_DATE
,      MAX_LINE_NUMBER
,      BID_RANKING
,      RANK_INDICATOR
,      SHOW_BIDDER_SCORES
,      OPEN_AUCTION_NOW_FLAG
,      PUBLISH_AUCTION_NOW_FLAG
,      TEMPLATE_ID
,      REMINDER_DATE
,      ORG_ID
,      BUYER_ID
,      MANUAL_EDIT_FLAG
,      WF_PONCOMPL_ITEM_KEY
,      HAS_PE_FOR_ALL_ITEMS
,      HAS_PRICE_ELEMENTS
,      PO_MIN_REL_AMOUNT
,      GLOBAL_AGREEMENT_FLAG
,      OUTCOME_STATUS
,      SOURCE_REQS_FLAG
,      AWARD_COMPLETE_DATE
,      WF_PONCOMPL_CURRENT_ROUND
,      SECURITY_LEVEL_CODE
,      WF_APPROVAL_ITEM_KEY
,      APPROVAL_STATUS
,      SOURCE_DOC_ID
,      SOURCE_DOC_NUMBER
,      SOURCE_DOC_MSG
,      SOURCE_DOC_LINE_MSG
,      SOURCE_DOC_MSG_APP
,      SHARE_AWARD_DECISION
,      DESCRIPTION
,      TEMPLATE_SCOPE
,      TEMPLATE_STATUS
,      IS_TEMPLATE_FLAG
,      AWARD_APPROVAL_FLAG
,      AWARD_APPROVAL_STATUS
,      AWARD_APPR_AME_TRANS_ID
,      AWARD_APPR_AME_TRANS_PREV_ID
,      WF_AWARD_APPROVAL_ITEM_KEY
,      AMENDMENT_NUMBER
,      AMENDMENT_DESCRIPTION
,      AUCTION_HEADER_ID_ORIG_AMEND
,      AUCTION_HEADER_ID_PREV_AMEND
,      DOCUMENT_NUMBER
,      AWARD_APPR_AME_TXN_DATE
,      HDR_ATTR_ENABLE_WEIGHTS
,      HDR_ATTR_DISPLAY_SCORE
,      HDR_ATTR_MAXIMUM_SCORE
,      ATTRIBUTE_LINE_NUMBER
,      CONTERMS_EXIST_FLAG
,      CONTERMS_ARTICLES_UPD_DATE
,      CONTERMS_DELIV_UPD_DATE
,      AWARD_MODE
,      HAS_HDR_ATTR_FLAG
,      AWARD_DATE
,      MAX_INTERNAL_LINE_NUM
,      MAX_BID_COLOR_SEQUENCE_ID
,      HAS_ITEMS_FLAG
,      INT_ATTRIBUTE_CATEGORY
,      INT_ATTRIBUTE1
,      INT_ATTRIBUTE2
,      INT_ATTRIBUTE3
,      INT_ATTRIBUTE4
,      INT_ATTRIBUTE5
,      INT_ATTRIBUTE6
,      INT_ATTRIBUTE7
,      INT_ATTRIBUTE8
,      INT_ATTRIBUTE9
,      INT_ATTRIBUTE10
,      INT_ATTRIBUTE11
,      INT_ATTRIBUTE12
,      INT_ATTRIBUTE13
,      INT_ATTRIBUTE14
,      INT_ATTRIBUTE15
,      EXT_ATTRIBUTE_CATEGORY
,      EXT_ATTRIBUTE1
,      EXT_ATTRIBUTE2
,      EXT_ATTRIBUTE3
,      EXT_ATTRIBUTE4
,      EXT_ATTRIBUTE5
,      EXT_ATTRIBUTE6
,      EXT_ATTRIBUTE7
,      EXT_ATTRIBUTE8
,      EXT_ATTRIBUTE9
,      EXT_ATTRIBUTE10
,      EXT_ATTRIBUTE11
,      EXT_ATTRIBUTE12
,      EXT_ATTRIBUTE13
,      EXT_ATTRIBUTE14
,      EXT_ATTRIBUTE15
,      INCLUDE_PDF_IN_EXTERNAL_PAGE
,      ABSTRACT_DETAILS
,      ABSTRACT_STATUS
,      PF_TYPE_ALLOWED
,      SUPPLIER_VIEW_TYPE
,      IS_PAUSED
,      PAUSE_REMARKS
,      LAST_PAUSE_DATE
,      MAX_DOCUMENT_LINE_NUM
,      PROGRESS_PAYMENT_TYPE
,      ADVANCE_NEGOTIABLE_FLAG
,      RECOUPMENT_NEGOTIABLE_FLAG
,      PROGRESS_PYMT_NEGOTIABLE_FLAG
,      RETAINAGE_NEGOTIABLE_FLAG
,      MAX_RETAINAGE_NEGOTIABLE_FLAG
,      SUPPLIER_ENTERABLE_PYMT_FLAG
,      PROJECT_ID
,      TEAM_SCORING_ENABLED_FLAG
,      HAS_SCORING_TEAMS_FLAG
,      SCORING_LOCK_DATE
,      SCORING_LOCK_TP_CONTACT_ID
,      REQUEST_ID
,      REQUEST_DATE
,      REQUESTED_BY
,      IMPORT_FILE_NAME
,      NUMBER_OF_LINES
,      LAST_LINE_NUMBER
,      STYLE_ID
,      LINE_ATTRIBUTE_ENABLED_FLAG
,      LINE_MAS_ENABLED_FLAG
,      PRICE_ELEMENT_ENABLED_FLAG
,      RFI_LINE_ENABLED_FLAG
,      LOT_ENABLED_FLAG
,      GROUP_ENABLED_FLAG
,      LARGE_NEG_ENABLED_FLAG
,      HDR_ATTRIBUTE_ENABLED_FLAG
,      NEG_TEAM_ENABLED_FLAG
,      PROXY_BIDDING_ENABLED_FLAG
,      POWER_BIDDING_ENABLED_FLAG
,      AUTO_EXTEND_ENABLED_FLAG
,      PO_STYLE_ID
,      PRICE_BREAK_RESPONSE
,      GLOBAL_TEMPLATE_FLAG
,      CONTRACT_TEMPLATE_ID
,      COMPLETE_FLAG
,      BID_DECREMENT_METHOD
,      DISPLAY_BEST_PRICE_BLIND_FLAG
,      FIRST_LINE_CLOSE_DATE
,      STAGGERED_CLOSING_INTERVAL
,      ENFORCE_PREVRND_BID_PRICE_FLAG
,      PRICE_TIERS_INDICATOR
,      AUTO_EXTEND_MIN_TRIGGER_RANK
,      QTY_PRICE_TIERS_ENABLED_FLAG
,      TWO_PART_FLAG
,      TECHNICAL_LOCK_STATUS
,      TECHNICAL_EVALUATION_STATUS
,      TECHNICAL_ACTUAL_UNLOCK_DATE
,      TECHNICAL_ACTUAL_UNSEAL_DATE
,      TECHNICAL_UNLOCK_TP_CONTACT_ID
,      TECHNICAL_UNSEAL_TP_CONTACT_ID
,      NO_OF_NOTIFICATIONS_SENT
,      EMD_ENABLE_FLAG
,      EMD_AMOUNT
,      EMD_DUE_DATE
,      EMD_TYPE
,      EMD_GUARANTEE_EXPIRY_DATE
,      EMD_ADDITIONAL_INFORMATION
,      POST_EMD_TO_FINANCE
,      NEGOTIATION_REQUESTER_ID
,      SUPP_REG_QUAL_FLAG
,      SUPP_EVAL_FLAG
,      HIDE_TERMS_FLAG
,      HIDE_ABSTRACT_FORMS_FLAG
,      HIDE_ATTACHMENTS_FLAG
,      INTERNAL_EVAL_FLAG
,      HDR_SUPP_ATTR_ENABLED_FLAG
,      INTGR_HDR_ATTR_FLAG
,      INTGR_HDR_ATTACH_FLAG
,      LINE_SUPP_ATTR_ENABLED_FLAG
,      ITEM_SUPP_ATTR_ENABLED_FLAG
,      INTGR_CAT_LINE_ATTR_FLAG
,      INTGR_ITEM_LINE_ATTR_FLAG
,      INTGR_CAT_LINE_ASL_FLAG
,      INTERNAL_ONLY_FLAG
,      SYNC_STATUS
,      REVISION
,      AMENDMENT_FLAG
,      CANCEL_AMENDMENT
,      EFFECTIVE_DATE
,      SIGNED_DATE
,      UDA_TEMPLATE_ID
,      UDA_TEMPLATE_DATE
,      SOLICITATION_TYPE
,      NO_OF_COPIES
,      CD_GENERATED_DATE
,      CD_EDITBYUSER_FLAG
,      CD_GENERATED_FLAG
,      AMENDUPDATED_AFTERCDGENERATED
,      CHANGEDESCRIPTION_DATA
,      CONCURRENT_REQID
,      STANDARD_FORM
,      DOCUMENT_FORMAT
,      FEDERAL_PUBLICATION_EXCEPTION
,      UMBRELLA_PROGRAM_ID
,      FAIR_OPP_NOTICE_FLAG
,      ALLOW_WITHDRAW_FLAG
,      ALLOW_UNSOL_OFFER_LINES
,      ALLOW_MULTIPLE_ACTIVE_OFFERS
,      ALLOW_STAGGERED_AWARDS
FROM PON.PON_AUCTION_HEADERS_ALL#;

Dependencies

[top of page]

PON.PON_AUCTION_HEADERS_ALL# references the following:

SchemaPON
TablePON_AUCTION_HEADERS_ALL
PON.PON_AUCTION_HEADERS_ALL# is referenced by following:

SchemaAPPS
SynonymPON_AUCTION_HEADERS
SynonymPON_AUCTION_HEADERS_ALL