Skip to content

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 Comments
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:

SchemaPON
TablePON_AUCTION_TEMPLATES
PON.PON_AUCTION_TEMPLATES# is referenced by following:

SchemaAPPS
SynonymPON_AUCTION_TEMPLATES