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: ViewPON.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:

SchemaAPPS
SynonymPON_AUCTION_HEADERS_ALL
SynonymPON_BID_HEADERS

APPS.PON_AUC_NOTIF_DELIV_V is not referenced by any database object