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_SAVINGS_V

Object Details

Object Name:	PON_MI_AUC_SAVINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_MI_AUC_SAVINGS_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
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
COMPLETED_DATE	DATE			Awarded Date
CURRENCY_CODE	VARCHAR2	(15)		Currency code
CATEGORY_ID	NUMBER			Bid item's unique category id
AUCTION_NUMBER	NUMBER		Yes	System-generated unique auction number
AUCTION_TITLE	VARCHAR2	(80)		Auction title
BUYER_CONTACT_ID	NUMBER			Buyer's trading partner's contact id
BUYER_CONTACT_NAME	VARCHAR2	(255)		Buyer's trading partner's contact name
SAVINGS	NUMBER			Amount (price*quantity) saved, calculated by comparing awarded bid price to item price
INITIAL_BID	NUMBER			The price of the first bid
PRICE	NUMBER			Item's price
AWARD_QUANTITY	NUMBER			Awarded quantity
ITEM_DESCRIPTION	VARCHAR2	(2500)		Item description
ITEM_NUMBER	VARCHAR2	(820)		Item Number
ITEM_REVISION	VARCHAR2	(3)		Item Revision
INTERNAL_NAME	VARCHAR2	(50)		Negotiation Type Internal Name

Query Text

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


SELECT BUYER_ID
,      BUYER_NAME
,      SELLER_ID
,      SELLER_NAME
,      COMPLETED_DATE
,      CURRENCY_CODE
,      CATEGORY_ID
,      AUCTION_NUMBER
,      AUCTION_TITLE
,      BUYER_CONTACT_ID
,      BUYER_CONTACT_NAME
,      SAVINGS
,      INITIAL_BID
,      PRICE
,      AWARD_QUANTITY
,      ITEM_DESCRIPTION
,      ITEM_NUMBER
,      ITEM_REVISION
,      INTERNAL_NAME
FROM APPS.PON_MI_AUC_SAVINGS_V;

Dependencies

[top of page]

APPS.PON_MI_AUC_SAVINGS_V references the following:

APPS: PON_AUCTION_HEADERS; PON_AUCTION_ITEM_PRICES_ALL; PON_AUC_DOCTYPES; PON_BID_HEADERS; PON_BID_ITEM_PRICES

APPS.PON_MI_AUC_SAVINGS_V is not referenced by any database object