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.OTFV_PRICE_LIST_ENTRIES

Object Details

Object Name:	OTFV_PRICE_LIST_ENTRIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OTA.OTFV_PRICE_LIST_ENTRIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the information about price list entries.
Price list entries can define price list as a per studen or customert price.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	The name of the Business Group
PRICE_LIST_ENTRY_COMMENTS	VARCHAR2	(2000)		Comments about the price list entry
PRICE	NUMBER		Yes	The standard price per delegate
PRICE_BASIS	VARCHAR2	(4000)		Defines whether entry is for a delegate or customer
ENTRY_START_DATE	DATE		Yes	The date from which the price is valid
ENTRY_END_DATE	DATE			The date this price is valid until
MAXIMUM_ATTENDEES	NUMBER	(9)		The max number of delegates for the price on a customer basis
MINIMUM_ATTENDEES	NUMBER	(9)		The min number of delegates for the price on a Customer basis
PRICE_LIST_NAME	VARCHAR2	(80)	Yes	The name of the price list
PRICE_LIST_TYPE	VARCHAR2	(4000)		The type of price list
DEFAULT_PRICE_LIST	VARCHAR2	(4000)		Indicates whether the price list is the default
PRICE_LIST_DESCRIPTION	VARCHAR2	(240)		Description of Price List
TRAINING_UNITS	VARCHAR2	(30)		The type of unit being specified for the Price
UNIT_PRICE	NUMBER	(9)		The price of a single unit in the specified currency
PRICE_LIST_CURRENCY	VARCHAR2	(4000)		The currency in which the price list is defined
PRICE_LIST_DATE_FROM	DATE		Yes	The date from which the price list is valid
PRICE_LIST_DATE_TO	DATE			The date the Price List is valid until
ACTIVITY_NAME	VARCHAR2	(80)		The Name of the Activity
ACTIVITY_TYPE	VARCHAR2	(240)		The Type of Activity
_DF	CHAR	(34)		Descriptive Flex Fields
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	System generated key for the Business Group
ACTIVITY_VERSION_ID	NUMBER	(9)		System generated key for Activity
ACTIVITY_ID	NUMBER	(9)		System generated key for the Activity Type
PRICE_LIST_ID	NUMBER	(9)	Yes	System generated key for this price list
PRICE_LIST_ENTRY_ID	NUMBER	(9)	Yes	System generated key for this price list entry
RCO_ID	NUMBER

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PRICE_LIST_ENTRY_COMMENTS
,      PRICE
,      PRICE_BASIS
,      ENTRY_START_DATE
,      ENTRY_END_DATE
,      MAXIMUM_ATTENDEES
,      MINIMUM_ATTENDEES
,      PRICE_LIST_NAME
,      PRICE_LIST_TYPE
,      DEFAULT_PRICE_LIST
,      PRICE_LIST_DESCRIPTION
,      TRAINING_UNITS
,      UNIT_PRICE
,      PRICE_LIST_CURRENCY
,      PRICE_LIST_DATE_FROM
,      PRICE_LIST_DATE_TO
,      ACTIVITY_NAME
,      ACTIVITY_TYPE
,      _DF
,      BUSINESS_GROUP_ID
,      ACTIVITY_VERSION_ID
,      ACTIVITY_ID
,      PRICE_LIST_ID
,      PRICE_LIST_ENTRY_ID
,      RCO_ID
FROM APPS.OTFV_PRICE_LIST_ENTRIES;

Dependencies

[top of page]

APPS.OTFV_PRICE_LIST_ENTRIES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; OTA_ACTIVITY_DEFINITIONS; OTA_ACTIVITY_DEFINITIONS_TL; OTA_ACTIVITY_VERSIONS; OTA_ACTIVITY_VERSIONS_TL; OTA_GENERAL - show dependent code; OTA_PRICE_LISTS; OTA_PRICE_LIST_ENTRIES

APPS.OTFV_PRICE_LIST_ENTRIES is not referenced by any database object