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: APPS.PON_AUC_NOTIF_DELIV_V

Object Details

Object Name:	PON_AUC_NOTIF_DELIV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_AUC_NOTIF_DELIV_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_NUMBER	VARCHAR2	(240)		Auction number
AUCTION_TITLE	VARCHAR2	(80)		Auction title
BID_NUMBER	NUMBER		Yes	System-generated unique number
SUPPLIER_PARTY_ID	NUMBER			Identifier for bidder trading partner
SUPPLIER_PARTY_NAME	VARCHAR2	(255)		Bidder trading partner name
SUPPLIER_CONTACT_ID	NUMBER			Identifier for contact person of bidder trading partner
SUPPLIER_CONTACT_USER_NAME	VARCHAR2	(255)		Contact person for Bidder trading partner
AUCTION_OPEN_DATE	DATE			Date that auction is open for bidding
AUCTION_CLOSE_DATE	DATE			Current date that auction closes for bidding (Bids will not be accepted from this date onward)

Query Text

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


SELECT AUCTION_NUMBER
,      AUCTION_TITLE
,      BID_NUMBER
,      SUPPLIER_PARTY_ID
,      SUPPLIER_PARTY_NAME
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_USER_NAME
,      AUCTION_OPEN_DATE
,      AUCTION_CLOSE_DATE
FROM APPS.PON_AUC_NOTIF_DELIV_V;

Dependencies

[top of page]

APPS.PON_AUC_NOTIF_DELIV_V references the following:

APPS: PON_AUCTION_HEADERS_ALL; PON_BID_HEADERS

APPS.PON_AUC_NOTIF_DELIV_V is not referenced by any database object