eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: PON.PON_AUCTION_TEMPLATES#

Object Details

Object Name:	PON_AUCTION_TEMPLATES#
Object Type:	VIEW
Owner:	PON
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
NAME	VARCHAR2	(80)	Yes
DESCRIPTION	VARCHAR2	(250)
TEMPLATE_ID	NUMBER		Yes
TEMPLATE_TYPE	VARCHAR2	(25)	Yes
STATUS	VARCHAR2	(25)
SCOPE	VARCHAR2	(25)
STATUS_DSP	VARCHAR2	(25)
AUCTION_TYPE	VARCHAR2	(25)
AUCTION_DURATION	NUMBER
AUCTION_DURATION_UNIT	VARCHAR2	(25)
BID_VISIBILITY_CODE	VARCHAR2	(25)
BID_LIST_TYPE	VARCHAR2	(25)
BID_FREQUENCY_CODE	VARCHAR2	(25)
BID_SCOPE_CODE	VARCHAR2	(25)
CURRENCY_CODE	VARCHAR2	(25)
PAYMENT_TERMS_ID	NUMBER
PAYMENT_TERMS_CODE	VARCHAR2	(25)
PAYMENT_TERMS	VARCHAR2	(80)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
FREIGHT_TERMS	VARCHAR2	(80)
CARRIER_CODE	VARCHAR2	(25)
CARRIER	VARCHAR2	(80)
FOB_CODE	VARCHAR2	(25)
FOB	VARCHAR2	(80)
NUMBER_PRICE_DECIMALS	NUMBER
NOTE_TO_BIDDERS	VARCHAR2	(4000)
CONTRACT_TYPE	VARCHAR2	(25)
SHIP_TO_LOCATION_ID	NUMBER
BILL_TO_LOCATION_ID	NUMBER
ATTACHMENT_FLAG	VARCHAR2	(1)
AUTO_EXTEND_FLAG	VARCHAR2	(1)
AUTO_EXTEND_NUMBER	NUMBER
PRICE_DRIVEN_AUCTION_FLAG	VARCHAR2	(1)
MIN_BID_DECREMENT	NUMBER
TRADING_PARTNER_CONTACT_NAME	VARCHAR2	(255)
TRADING_PARTNER_CONTACT_ID	NUMBER
TRADING_PARTNER_NAME	VARCHAR2	(255)
TRADING_PARTNER_ID	NUMBER
TIME_ZONE	VARCHAR2	(25)
NUMBER_OF_EXTENSIONS	NUMBER
NUMBER_OF_BIDS	NUMBER
LANGUAGE_CODE	VARCHAR2	(25)
RATE_TYPE	VARCHAR2	(25)
RATE_DATE	DATE
RATE	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
TRADING_PARTNER_NAME_UPPER	VARCHAR2	(255)
AUTO_EXTEND_ALL_LINES_FLAG	VARCHAR2	(1)
AUTO_EXTEND_DURATION	NUMBER
PROXY_BID_ALLOWED_FLAG	VARCHAR2	(1)
PUBLISH_RATES_TO_BIDDERS_FLAG	VARCHAR2	(1)
MIN_BID_INCREMENT	NUMBER
ALLOW_OTHER_BID_CURRENCY_FLAG	VARCHAR2	(1)
SHIPPING_TERMS_CODE	VARCHAR2	(25)
SHIPPING_TERMS	VARCHAR2	(80)
SHIPPING_METHOD_CODE	VARCHAR2	(25)
SHIPPING_METHOD	VARCHAR2	(80)
ATTRIBUTES_EXIST	VARCHAR2	(20)
OPEN_AUCTION_IMMEDIATELY_FLAG	VARCHAR2	(1)
CATEGORY_ID	NUMBER
CATEGORY_NAME	VARCHAR2	(250)
FULL_QUANTITY_BID_CODE	VARCHAR2	(30)
MIN_BID_CHANGE_TYPE	VARCHAR2	(30)
MODE_OF_TRANSPORT	VARCHAR2	(80)
MODE_OF_TRANSPORT_CODE	VARCHAR2	(25)
AUTO_EXTEND_TYPE_FLAG	VARCHAR2	(25)
MULTIPLE_ROUNDS_FLAG	VARCHAR2	(1)
DOCTYPE_ID	NUMBER
OFFER_TYPE	VARCHAR2	(30)
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
MAX_RESPONSES	NUMBER
MAX_RESPONSE_ITERATIONS	NUMBER
PO_AGREED_AMOUNT	NUMBER
RESPONSE_ALLOWED_FLAG	VARCHAR2	(1)
FOB_NEG_FLAG	VARCHAR2	(1)
CARRIER_NEG_FLAG	VARCHAR2	(1)
FREIGHT_TERMS_NEG_FLAG	VARCHAR2	(1)
PAYMENT_TERMS_NEG_FLAG	VARCHAR2	(1)
MODE_OF_TRANSPORT_NEG_FLAG	VARCHAR2	(1)
MANUAL_CLOSE_FLAG	VARCHAR2	(1)
MANUAL_EXTEND_FLAG	VARCHAR2	(1)
AUTOEXTEND_CHANGED_FLAG	VARCHAR2	(1)
SHIPPING_METHOD_NEG_FLAG	VARCHAR2	(1)
SHIPPING_TERMS_NEG_FLAG	VARCHAR2	(1)
USE_REGIONAL_PRICING_FLAG	VARCHAR2	(1)
SHOW_BIDDER_NOTES	VARCHAR2	(1)
BID_RANKING	VARCHAR2	(240)
RANK_INDICATOR	VARCHAR2	(240)
SHOW_BIDDER_SCORES	VARCHAR2	(240)
HAS_PRICE_ELEMENTS_FLAG	VARCHAR2	(240)
PO_MIN_REL_AMOUNT	NUMBER
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)
SECURITY_LEVEL_CODE	VARCHAR2	(25)

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# references the following:

PON: PON_AUCTION_TEMPLATES

PON.PON_AUCTION_TEMPLATES# is referenced by following:

APPS: PON_AUCTION_TEMPLATES