[Home] [Help] [Dependency Information]

VIEW: APPS.PON_AUCTION_HEADERS_V

Object Details

Object Name:	PON_AUCTION_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_AUCTION_HEADERS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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
,      AUCTION_SORTCOL
,      CREATED_BY_FULL_NAME
,      NAME
,      DOCUMENT_NUMBER
,      NEGOTIATION_STATUS
,      SHARE_AWARD_DECISION
,      DESCRIPTION
,      TEMPLATE_SCOPE
,      TEMPLATE_STATUS
,      IS_TEMPLATE_FLAG
,      AMENDMENT_NUMBER
,      AMENDMENT_DESCRIPTION
,      AUCTION_HEADER_ID_ORIG_AMEND
,      AUCTION_HEADER_ID_PREV_AMEND
,      AWARD_APPROVAL_FLAG
,      AWARD_APPROVAL_STATUS
,      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
,      SUPPL_NEGOTIATION_STATUS
,      MAX_BID_COLOR_SEQUENCE_ID
,      HAS_ITEMS_FLAG
,      PF_TYPE_ALLOWED
,      SUPPLIER_VIEW_TYPE
,      IS_PAUSED
,      PAUSE_REMARKS
,      LAST_PAUSE_DATE
,      ACTUAL_CLOSE_BIDDING_DATE
,      MAX_DOCUMENT_LINE_NUM
,      ABSTRACT_STATUS
,      ABSTRACT_DETAILS
,      INCLUDE_PDF_IN_EXTERNAL_PAGE
,      TEAM_SCORING_ENABLED_FLAG
,      HAS_SCORING_TEAMS_FLAG
,      SCORING_LOCK_DATE
,      SCORING_LOCK_TP_CONTACT_ID
,      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
,      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
,      REQUEST_ID
,      NUMBER_OF_LINES
,      STAGGERED_CLOSING_INTERVAL
,      FIRST_LINE_CLOSE_DATE
,      PRICE_TIERS_INDICATOR
,      ENFORCE_PREVRND_BID_PRICE_FLAG
FROM APPS.PON_AUCTION_HEADERS_V;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

HR_ALL_ORGANIZATION_UNITS_TL

HZ_PARTIES

PON_AUCTION_HEADERS

PON_LOCALE_PKG - show dependent code

APPS.PON_AUCTION_HEADERS_V is not referenced by any database object