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_BIDDING_PARTIES#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
AUCTION_HEADER_ID	NUMBER
LIST_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
SEQUENCE	NUMBER
TRADING_PARTNER_NAME	VARCHAR2	(240)
TRADING_PARTNER_ID	NUMBER
TRADING_PARTNER_CONTACT_NAME	VARCHAR2	(240)
TRADING_PARTNER_CONTACT_ID	NUMBER
NEW_SUPPLIER_NAME	VARCHAR2	(240)
NEW_SUPPLIER_CONTACT_FNAME	VARCHAR2	(240)
NEW_SUPPLIER_CONTACT_LNAME	VARCHAR2	(240)
NEW_SUPPLIER_EMAIL	VARCHAR2	(240)
NOTE_TO_NEW_SUPPLIER	VARCHAR2	(240)
WF_USER_NAME	VARCHAR2	(30)
INVITATION_ID	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
AUCTION_CREATION_DATE	DATE
BID_CURRENCY_CODE	VARCHAR2	(15)
NUMBER_PRICE_DECIMALS	NUMBER
RATE	NUMBER
DERIVE_TYPE	VARCHAR2	(8)
ADDITIONAL_CONTACT_EMAIL	VARCHAR2	(240)
ROUND_NUMBER	NUMBER
SUPP_ACKNOWLEDGEMENT	VARCHAR2	(1)
ACK_PARTNER_CONTACT_NAME	VARCHAR2	(240)
ACK_PARTNER_CONTACT_ID	NUMBER
ACKNOWLEDGEMENT_TIME	DATE
ACK_NOTE_TO_AUCTIONEER	VARCHAR2	(4000)
REGISTRATION_ID	NUMBER
RATE_DSP	NUMBER
WF_ITEM_KEY	VARCHAR2	(240)
LAST_AMENDMENT_UPDATE	NUMBER
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
MODIFIED_FLAG	VARCHAR2	(1)
ACCESS_TYPE	VARCHAR2	(25)
REQUESTED_SUPPLIER_ID	NUMBER
REQUESTED_SUPPLIER_CONTACT_ID	NUMBER
REQUESTED_SUPPLIER_NAME	VARCHAR2	(240)
REQUESTED_SUPP_CONTACT_NAME	VARCHAR2	(300)
FROM_EMD_FLAG	VARCHAR2	(1)
EXEMPT_FLAG	VARCHAR2	(1)

Query Text

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


SELECT AUCTION_HEADER_ID
,      LIST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SEQUENCE
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      NEW_SUPPLIER_NAME
,      NEW_SUPPLIER_CONTACT_FNAME
,      NEW_SUPPLIER_CONTACT_LNAME
,      NEW_SUPPLIER_EMAIL
,      NOTE_TO_NEW_SUPPLIER
,      WF_USER_NAME
,      INVITATION_ID
,      CREATION_DATE
,      CREATED_BY
,      AUCTION_CREATION_DATE
,      BID_CURRENCY_CODE
,      NUMBER_PRICE_DECIMALS
,      RATE
,      DERIVE_TYPE
,      ADDITIONAL_CONTACT_EMAIL
,      ROUND_NUMBER
,      SUPP_ACKNOWLEDGEMENT
,      ACK_PARTNER_CONTACT_NAME
,      ACK_PARTNER_CONTACT_ID
,      ACKNOWLEDGEMENT_TIME
,      ACK_NOTE_TO_AUCTIONEER
,      REGISTRATION_ID
,      RATE_DSP
,      WF_ITEM_KEY
,      LAST_AMENDMENT_UPDATE
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      MODIFIED_FLAG
,      ACCESS_TYPE
,      REQUESTED_SUPPLIER_ID
,      REQUESTED_SUPPLIER_CONTACT_ID
,      REQUESTED_SUPPLIER_NAME
,      REQUESTED_SUPP_CONTACT_NAME
,      FROM_EMD_FLAG
,      EXEMPT_FLAG
FROM PON.PON_BIDDING_PARTIES#;

Dependencies

[top of page]

PON.PON_BIDDING_PARTIES# references the following:

PON: PON_BIDDING_PARTIES

PON.PON_BIDDING_PARTIES# is referenced by following:

APPS: PON_BIDDING_PARTIES