DBA Data[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: ViewPON.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
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 (25)
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)
AUCTION_SORTCOL NUMBER

CREATED_BY_FULL_NAME VARCHAR2 (4000)
NAME VARCHAR2 (240)
DOCUMENT_NUMBER VARCHAR2 (240)
NEGOTIATION_STATUS VARCHAR2 (30)
SHARE_AWARD_DECISION VARCHAR2 (1)
DESCRIPTION VARCHAR2 (250)
TEMPLATE_SCOPE VARCHAR2 (25)
TEMPLATE_STATUS VARCHAR2 (25)
IS_TEMPLATE_FLAG VARCHAR2 (1)
AMENDMENT_NUMBER NUMBER

AMENDMENT_DESCRIPTION VARCHAR2 (4000)
AUCTION_HEADER_ID_ORIG_AMEND NUMBER

AUCTION_HEADER_ID_PREV_AMEND NUMBER

AWARD_APPROVAL_FLAG VARCHAR2 (1)
AWARD_APPROVAL_STATUS VARCHAR2 (30)
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

SUPPL_NEGOTIATION_STATUS VARCHAR2 (9)
MAX_BID_COLOR_SEQUENCE_ID NUMBER

HAS_ITEMS_FLAG VARCHAR2 (1)
PF_TYPE_ALLOWED VARCHAR2 (30)
SUPPLIER_VIEW_TYPE VARCHAR2 (30)
IS_PAUSED VARCHAR2 (1)
PAUSE_REMARKS VARCHAR2 (2000)
LAST_PAUSE_DATE DATE

ACTUAL_CLOSE_BIDDING_DATE DATE

MAX_DOCUMENT_LINE_NUM NUMBER

ABSTRACT_STATUS VARCHAR2 (20)
ABSTRACT_DETAILS VARCHAR2 (4000)
INCLUDE_PDF_IN_EXTERNAL_PAGE VARCHAR2 (1)
TEAM_SCORING_ENABLED_FLAG VARCHAR2 (1)
HAS_SCORING_TEAMS_FLAG VARCHAR2 (1)
SCORING_LOCK_DATE DATE

SCORING_LOCK_TP_CONTACT_ID 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

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

REQUEST_ID NUMBER

NUMBER_OF_LINES NUMBER

STAGGERED_CLOSING_INTERVAL NUMBER

Staggered line closing interval.
FIRST_LINE_CLOSE_DATE DATE

Date at which the first line is schedueld to close in a staggered closing scenerio.
PRICE_TIERS_INDICATOR VARCHAR2 (30)
Indicates the price tier type of the lines in the auction - NONE- PRICE_BREAKS or QUANTITY_TIERS
ENFORCE_PREVRND_BID_PRICE_FLAG VARCHAR2 (1)
When this flag is set, each supplier user sees his previous active bid's quoted price as the start price of each line. This flag can only be set by the buyer when creating a new round. It cannot be set for the first round. For example, if the start price of a line is $100 in the first round, the supplier bids $95 and this control is set in the second round, then the supplier will see a start price of $95 for this line in the second round.
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.PON_AUCTION_HEADERS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHZ_PARTIES
SynonymPON_AUCTION_HEADERS
PL/SQL PackagePON_LOCALE_PKG - show dependent code

APPS.PON_AUCTION_HEADERS_V is not referenced by any database object