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_SYSTEM_FIELDS_VALUES_V

Object Details

Object Name:	PON_SYSTEM_FIELDS_VALUES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PON.PON_SYSTEM_FIELDS_VALUES_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_HEADER_ID	NUMBER		Yes	Corresponds to pon_auction_headers_all.AUCTION_HEADER_ID
NEGOTIATION_NUM	VARCHAR2	(240)		Corresponds to displayed document number
NEGOTIATION_TYPE	VARCHAR2	(50)	Yes	Corresponds to the type of negotiation like RFQ, Auction, RFI, etc
NEGOTIATION_TYPE_NAME	VARCHAR2	(50)	Yes	Corresponds to user-displayed value of type of negotiation
ORGANIZATION	NUMBER			Corresponds to organization ID for current negotiation
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	User-displayed value of the organization
OPEN_DATE	DATE			Open bidding date of negotiation
PREVIEW_DATE	DATE			Preview date of the negotiation
AWARD_DATE	DATE			Award Date of the current negotiation
AMENDMENT_DESCRIPTION	VARCHAR2	(4000)		Amendment description entered by buyer for amended auctions
CLOSE_DATE	DATE			Close bidding date of current negotiation
TITLE	VARCHAR2	(80)		Negotiation title
STYLE	VARCHAR2	(25)		Buyer security style for current negotiation - private, public, etc
STYLE_NAME	VARCHAR2	(80)		User-displayed style for current negotiation
BUYER	VARCHAR2	(255)		Name of the buyer
EVENT	VARCHAR2	(80)		Name of the event associated with current negotiation
PAYMENT_TERMS	NUMBER			Payment terms - internal code
PAYMENT_TERMS_NAME	VARCHAR2	(50)		Payment terms - user-displayed value
CARRIER	VARCHAR2	(25)		Carrier - internal code
CARRIER_NAME	VARCHAR2	(4000)		Carrier - user-displayed value
FOB	VARCHAR2	(25)		FOB -- internal code
FOB_NAME	VARCHAR2	(80)		FOB - user displayed value
FREIGHT_TERMS	VARCHAR2	(25)		Freight terms - internal code
FREIGHT_TERMS_NAME	VARCHAR2	(80)		Freight terms - user-displayed value
NEGOTIATION_CURR	VARCHAR2	(15)		Negotiation currency of current auction
ABSTRACT_STATUS	VARCHAR2	(20)		Internal status of the abstract - published or not
DISPLAY_PDF_FLAG	VARCHAR2	(8)		Flag to indicate whether buyer wishes to display PDF document to suppliers
IS_PAUSED	VARCHAR2	(1)		Flag to indicate whether auction is paused
TWO_PART_FLAG	VARCHAR2	(1)		Flag to indicate if the negotiation is a two part RFQ.

Query Text

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


SELECT AUCTION_HEADER_ID
,      NEGOTIATION_NUM
,      NEGOTIATION_TYPE
,      NEGOTIATION_TYPE_NAME
,      ORGANIZATION
,      ORGANIZATION_NAME
,      OPEN_DATE
,      PREVIEW_DATE
,      AWARD_DATE
,      AMENDMENT_DESCRIPTION
,      CLOSE_DATE
,      TITLE
,      STYLE
,      STYLE_NAME
,      BUYER
,      EVENT
,      PAYMENT_TERMS
,      PAYMENT_TERMS_NAME
,      CARRIER
,      CARRIER_NAME
,      FOB
,      FOB_NAME
,      FREIGHT_TERMS
,      FREIGHT_TERMS_NAME
,      NEGOTIATION_CURR
,      ABSTRACT_STATUS
,      DISPLAY_PDF_FLAG
,      IS_PAUSED
,      TWO_PART_FLAG
FROM APPS.PON_SYSTEM_FIELDS_VALUES_V;

Dependencies

[top of page]

APPS.PON_SYSTEM_FIELDS_VALUES_V references the following:

APPS: AP_TERMS_VL; FINANCIALS_SYSTEM_PARAMS_ALL; FND_LOOKUP_VALUES; HR_ALL_ORGANIZATION_UNITS_TL; PON_AUCTION_HEADERS_ALL; PON_AUC_DOCTYPES; PON_AUC_DOCTYPES_TL; PON_FORMS_UTIL_PVT - show dependent code

APPS.PON_SYSTEM_FIELDS_VALUES_V is not referenced by any database object