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_MI_AUC_BUYERAUC_V

Object Details

Object Name:	PON_MI_AUC_BUYERAUC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_MI_AUC_BUYERAUC_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
PRICE	NUMBER			Awarded bid price
QUANTITY	NUMBER			Awarded quantity
LINE_NUMBER	NUMBER			Bid item's line number
ITEM_DESCRIPTION	VARCHAR2	(2500)		Bid item's description
AUCTION_NUMBER	NUMBER		Yes	System-generated unique auction number
AUCTION_TITLE	VARCHAR2	(80)		Auction title
AUCTION_DISPLAY_NUMBER	VARCHAR2	(81)		Auction number concatenated with auction round number
BID_NUMBER	NUMBER		Yes	System-generated bid number
BUYER_ID	NUMBER			Buyer's trading partner id
BUYER_NAME	VARCHAR2	(255)		Buyer's trading partner name
SELLER_ID	NUMBER			Seller's trading partner id
SELLER_NAME	VARCHAR2	(255)		Seller's trading partner name
BUYER_CONTACT_ID	NUMBER			Buyer's trading partner's contact id
BUYER_CONTACT_NAME	VARCHAR2	(255)		Buyer's trading partner's contact name
SELLER_CONTACT_ID	NUMBER			Seller's trading partner's contact id
SELLER_CONTACT_NAME	VARCHAR2	(255)		Seller's trading partner's contact name
CATEGORY_ID	NUMBER			Bid item's unique category id
CURRENCY_CODE	VARCHAR2	(15)		Auction's currency code
AUCTION_OUTCOME	VARCHAR2	(4)		Contract type: BLANKET, LONG, or SPOT
COMPLETED_DATE	DATE			Awarded Date

Query Text

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


SELECT PRICE
,      QUANTITY
,      LINE_NUMBER
,      ITEM_DESCRIPTION
,      AUCTION_NUMBER
,      AUCTION_TITLE
,      AUCTION_DISPLAY_NUMBER
,      BID_NUMBER
,      BUYER_ID
,      BUYER_NAME
,      SELLER_ID
,      SELLER_NAME
,      BUYER_CONTACT_ID
,      BUYER_CONTACT_NAME
,      SELLER_CONTACT_ID
,      SELLER_CONTACT_NAME
,      CATEGORY_ID
,      CURRENCY_CODE
,      AUCTION_OUTCOME
,      COMPLETED_DATE
FROM APPS.PON_MI_AUC_BUYERAUC_V;

Dependencies

[top of page]

APPS.PON_MI_AUC_BUYERAUC_V references the following:

APPS: PON_AUCTION_HEADERS; PON_AUC_DOCTYPES; PON_BID_HEADERS; PON_BID_ITEM_PRICES

APPS.PON_MI_AUC_BUYERAUC_V is referenced by following:

APPS: PON_MI_AUCTIONSUMMARY_V