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

TABLE: PON.PON_AUCTION_TEMPLATES

Object Details
Object Name: PON_AUCTION_TEMPLATES
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_AUCTION_TEMPLATES
Subobject Name:
Status: VALID


PON_AUCTION_TEMPLATES stores negotiation template definitions that can be used to create auctions, offers, and RFQ transactions.
SCOPE column indicates whether this is a public or a private template.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUCTION_TEMPLATE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_ID
PON_AUCTION_TEMPLATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRADING_PARTNER_CONTACT_ID
PON_AUCTION_TEMPLATES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRADING_PARTNER_ID
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (80) Yes Auction template name
DESCRIPTION VARCHAR2 (250)
Auction template description
TEMPLATE_ID NUMBER
Yes System-generated unique Identifier of auction template
TEMPLATE_TYPE VARCHAR2 (25) Yes Auction template type(BUYER_TEMPLATE,SELLER_TEMPLATE)
STATUS VARCHAR2 (25)
Template status(ACTIVE,INACTIVE)
SCOPE VARCHAR2 (25)
Scope of visibility to indicate who can use this template, PRIVATE indicates that only auction creator can use the template, PUBLIC indicates that any one in the creator's company has access to the template.
STATUS_DSP VARCHAR2 (25)
No longer used
AUCTION_TYPE VARCHAR2 (25)
Auction type to denote whether selling(FORWARD) or buying(REVERSE) items
AUCTION_DURATION NUMBER

No longer used
AUCTION_DURATION_UNIT VARCHAR2 (25)
No longer used
BID_VISIBILITY_CODE VARCHAR2 (25)
Code specifying who in the system can view the bids
BID_LIST_TYPE VARCHAR2 (25)
Bid list type specifying if any registered exchange party can bid or by invitation only
BID_FREQUENCY_CODE VARCHAR2 (25)
Bid frequency code to indicate if only one bid per bidder is allowed or multiple bids are allowed
BID_SCOPE_CODE VARCHAR2 (25)
Bid scope code indicates if bidding for one item is allowed or all items must be bid
CURRENCY_CODE VARCHAR2 (25)
Code for currency of auction
PAYMENT_TERMS_ID NUMBER

Payment terms Identifier
PAYMENT_TERMS_CODE VARCHAR2 (25)
Code for payment terms
PAYMENT_TERMS VARCHAR2 (80)
No longer used
FREIGHT_TERMS_CODE VARCHAR2 (25)
Code for freight terms
FREIGHT_TERMS VARCHAR2 (80)
No longer used
CARRIER_CODE VARCHAR2 (25)
Code for carrier
CARRIER VARCHAR2 (80)
No longer used
FOB_CODE VARCHAR2 (25)
Code for free on board
FOB VARCHAR2 (80)
No longer used
NUMBER_PRICE_DECIMALS NUMBER

Required precision of bid price
NOTE_TO_BIDDERS VARCHAR2 (4000)
Note to bidders
CONTRACT_TYPE VARCHAR2 (25)
Type of contract - Spot Buy or Long Term agreement
SHIP_TO_LOCATION_ID NUMBER

Location Identifier to which auction items will be shipped
BILL_TO_LOCATION_ID NUMBER

Unique Identifier for billing address location
ATTACHMENT_FLAG VARCHAR2 (1)
Y or N flag to indicate attachments
AUTO_EXTEND_FLAG VARCHAR2 (1)
Y or N flag to indicate auto extensions are allowed
AUTO_EXTEND_NUMBER NUMBER

Number of allowed auto extensions
PRICE_DRIVEN_AUCTION_FLAG VARCHAR2 (1)
Y or N flag to indicate auction is price driven
MIN_BID_DECREMENT NUMBER

Minimum allowable price decrement for bid
TRADING_PARTNER_CONTACT_NAME VARCHAR2 (255)
Name of contact person for trading partner conducting auction
TRADING_PARTNER_CONTACT_ID NUMBER

Unique Identifier for contact person of trading partner conduction auction
TRADING_PARTNER_NAME VARCHAR2 (255)
Name of trading partner conductiong auction
TRADING_PARTNER_ID NUMBER

Unique Identifier for trading partner conductiong auction
TIME_ZONE VARCHAR2 (25)
Timezone in which auction is being held
NUMBER_OF_EXTENSIONS NUMBER

Number of extensions
NUMBER_OF_BIDS NUMBER

Number of bids received
LANGUAGE_CODE VARCHAR2 (25)
Code for language of auction
RATE_TYPE VARCHAR2 (25)
Currency conversion rate type
RATE_DATE DATE

Date of currency conversion rate
RATE NUMBER

Currency conversion rate
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
TRADING_PARTNER_NAME_UPPER VARCHAR2 (255)
Uppercase name of trading partner conducting auction
AUTO_EXTEND_ALL_LINES_FLAG VARCHAR2 (1)
Y or N falg to indicate that all items are autoextended if one item is autoextended
AUTO_EXTEND_DURATION NUMBER

Duration of autoextension (minutes)
PROXY_BID_ALLOWED_FLAG VARCHAR2 (1)
Y or N flag to indicate prixy bidding is allowed
PUBLISH_RATES_TO_BIDDERS_FLAG VARCHAR2 (1)
Y or N flag to indicate that conversion rates should be published to bidders
MIN_BID_INCREMENT NUMBER

Minimum allowable increment for bid
ALLOW_OTHER_BID_CURRENCY_FLAG VARCHAR2 (1)
Y or N flag to indicate other currencies are allowable for bids
SHIPPING_TERMS_CODE VARCHAR2 (25)
Code for shipping terms
SHIPPING_TERMS VARCHAR2 (80)
No longer used
SHIPPING_METHOD_CODE VARCHAR2 (25)
Code for shipping method
SHIPPING_METHOD VARCHAR2 (80)
No longer used
ATTRIBUTES_EXIST VARCHAR2 (20)
Item attributes exist
OPEN_AUCTION_IMMEDIATELY_FLAG VARCHAR2 (1)
Yor N flag to idicate if auction should be opened immediately
CATEGORY_ID NUMBER

Unique Identifier for category
CATEGORY_NAME VARCHAR2 (250)
Category name
FULL_QUANTITY_BID_CODE VARCHAR2 (30)
Full quantity bid code
MIN_BID_CHANGE_TYPE VARCHAR2 (30)
Minimum bid change type
MODE_OF_TRANSPORT VARCHAR2 (80)
Mode of transport
MODE_OF_TRANSPORT_CODE VARCHAR2 (25)
Code for mode of transport
AUTO_EXTEND_TYPE_FLAG VARCHAR2 (25)
Indicates the base date from which autoextension date is to be calculated
MULTIPLE_ROUNDS_FLAG VARCHAR2 (1)
Y or N flag to indicate if multiple rounds are allowed
DOCTYPE_ID NUMBER

Document type Identifier
OFFER_TYPE VARCHAR2 (30)
Offer type
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
Y or N flag to indicate if approval is required
MAX_RESPONSES NUMBER

Maximum responses
MAX_RESPONSE_ITERATIONS NUMBER

Maximum response iterations
PO_AGREED_AMOUNT NUMBER

Purchase order agreed amount
RESPONSE_ALLOWED_FLAG VARCHAR2 (1)
Y or N flag to idicate if response is allowed
FOB_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate if free on board is negotiable
CARRIER_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate if carrier is negotiable
FREIGHT_TERMS_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate if payment terms are negotiable
PAYMENT_TERMS_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate if payment terms are negotiable
MODE_OF_TRANSPORT_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate if mode of transport is negotiable
MANUAL_CLOSE_FLAG VARCHAR2 (1)
Y or N flag to indicate if the auction can be closed early
MANUAL_EXTEND_FLAG VARCHAR2 (1)
Y or N flag to indicate if the auction can be autoextended manaually
AUTOEXTEND_CHANGED_FLAG VARCHAR2 (1)
Not currently used
SHIPPING_METHOD_NEG_FLAG VARCHAR2 (1)
Not currently used
SHIPPING_TERMS_NEG_FLAG VARCHAR2 (1)
Not currently used
USE_REGIONAL_PRICING_FLAG VARCHAR2 (1)
Not currently used
SHOW_BIDDER_NOTES VARCHAR2 (1)
Flag indicating if bidder notes and attachments are visible to other bidders
BID_RANKING VARCHAR2 (240)
Bid evaluation method for this negotiation
RANK_INDICATOR VARCHAR2 (240)
Rank indicator for this negotiation
SHOW_BIDDER_SCORES VARCHAR2 (240)
whether scoring model is show to bidders
HAS_PRICE_ELEMENTS_FLAG VARCHAR2 (240)
Flag to indicate if templates has price element defined.
PO_MIN_REL_AMOUNT NUMBER

PO Minimum Release Amount
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
Global Agreement Flag
SECURITY_LEVEL_CODE VARCHAR2 (25)
Security level Code. Values are: PRIVATE/PUBLIC/HIERARCHY
Query Text

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


SELECT NAME
,      DESCRIPTION
,      TEMPLATE_ID
,      TEMPLATE_TYPE
,      STATUS
,      SCOPE
,      STATUS_DSP
,      AUCTION_TYPE
,      AUCTION_DURATION
,      AUCTION_DURATION_UNIT
,      BID_VISIBILITY_CODE
,      BID_LIST_TYPE
,      BID_FREQUENCY_CODE
,      BID_SCOPE_CODE
,      CURRENCY_CODE
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_CODE
,      PAYMENT_TERMS
,      FREIGHT_TERMS_CODE
,      FREIGHT_TERMS
,      CARRIER_CODE
,      CARRIER
,      FOB_CODE
,      FOB
,      NUMBER_PRICE_DECIMALS
,      NOTE_TO_BIDDERS
,      CONTRACT_TYPE
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      ATTACHMENT_FLAG
,      AUTO_EXTEND_FLAG
,      AUTO_EXTEND_NUMBER
,      PRICE_DRIVEN_AUCTION_FLAG
,      MIN_BID_DECREMENT
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      TIME_ZONE
,      NUMBER_OF_EXTENSIONS
,      NUMBER_OF_BIDS
,      LANGUAGE_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRADING_PARTNER_NAME_UPPER
,      AUTO_EXTEND_ALL_LINES_FLAG
,      AUTO_EXTEND_DURATION
,      PROXY_BID_ALLOWED_FLAG
,      PUBLISH_RATES_TO_BIDDERS_FLAG
,      MIN_BID_INCREMENT
,      ALLOW_OTHER_BID_CURRENCY_FLAG
,      SHIPPING_TERMS_CODE
,      SHIPPING_TERMS
,      SHIPPING_METHOD_CODE
,      SHIPPING_METHOD
,      ATTRIBUTES_EXIST
,      OPEN_AUCTION_IMMEDIATELY_FLAG
,      CATEGORY_ID
,      CATEGORY_NAME
,      FULL_QUANTITY_BID_CODE
,      MIN_BID_CHANGE_TYPE
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_CODE
,      AUTO_EXTEND_TYPE_FLAG
,      MULTIPLE_ROUNDS_FLAG
,      DOCTYPE_ID
,      OFFER_TYPE
,      APPROVAL_REQUIRED_FLAG
,      MAX_RESPONSES
,      MAX_RESPONSE_ITERATIONS
,      PO_AGREED_AMOUNT
,      RESPONSE_ALLOWED_FLAG
,      FOB_NEG_FLAG
,      CARRIER_NEG_FLAG
,      FREIGHT_TERMS_NEG_FLAG
,      PAYMENT_TERMS_NEG_FLAG
,      MODE_OF_TRANSPORT_NEG_FLAG
,      MANUAL_CLOSE_FLAG
,      MANUAL_EXTEND_FLAG
,      AUTOEXTEND_CHANGED_FLAG
,      SHIPPING_METHOD_NEG_FLAG
,      SHIPPING_TERMS_NEG_FLAG
,      USE_REGIONAL_PRICING_FLAG
,      SHOW_BIDDER_NOTES
,      BID_RANKING
,      RANK_INDICATOR
,      SHOW_BIDDER_SCORES
,      HAS_PRICE_ELEMENTS_FLAG
,      PO_MIN_REL_AMOUNT
,      GLOBAL_AGREEMENT_FLAG
,      SECURITY_LEVEL_CODE
FROM PON.PON_AUCTION_TEMPLATES;

Dependencies

[top of page]

PON.PON_AUCTION_TEMPLATES does not reference any database object

PON.PON_AUCTION_TEMPLATES is referenced by following:

SchemaAPPS
SynonymPON_AUCTION_TEMPLATES