View: OTFV_PRICE_LIST_ENTRIES

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_PRICE_LIST_ENTRIES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PLE.COMMENTS PRICE_LIST_ENTRY_COMMENTS
, PLE.PRICE PRICE
, HR_BIS.BIS_DECODE_LOOKUP('EVENT_PRICE_BASIS'
, PLE.PRICE_BASIS) PRICE_BASIS
, PLE.START_DATE ENTRY_START_DATE
, PLE.END_DATE ENTRY_END_DATE
, PLE.MAXIMUM_ATTENDEES MAXIMUM_ATTENDEES
, PLE.MINIMUM_ATTENDEES MINIMUM_ATTENDEES
, TPL.NAME PRICE_LIST_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PRICE_LIST_TYPE'
, TPL.PRICE_LIST_TYPE) PRICE_LIST_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TPL.DEFAULT_FLAG) DEFAULT_PRICE_LIST
, TPL.DESCRIPTION PRICE_LIST_DESCRIPTION
, TPL.TRAINING_UNIT_TYPE TRAINING_UNITS
, TPL.SINGLE_UNIT_PRICE UNIT_PRICE
, OTA_GENERAL.FND_CURRENCY_NAME(TPL.CURRENCY_CODE) PRICE_LIST_CURRENCY
, TPL.START_DATE PRICE_LIST_DATE_FROM
, TPL.END_DATE PRICE_LIST_DATE_TO
, TAV.VERSION_NAME ACTIVITY_NAME
, TAD.NAME ACTIVITY_TYPE
, '_DF:OTA:OTA_PRICE_LIST_ENTRIES:PLE'
, TPL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TPL.PRICE_LIST_ID PRICE_LIST_ID
, PLE.PRICE_LIST_ENTRY_ID PRICE_LIST_ENTRY_ID
, TAV.RCO_ID RCO_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_PRICE_LISTS TPL
, OTA_PRICE_LIST_ENTRIES PLE
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_DEFINITIONS TAD
WHERE PLE.PRICE_LIST_ID = TPL.PRICE_LIST_ID
AND TPL.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PLE.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID (+)
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID (+)
AND TPL.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TPL.BUSINESS_GROUP_ID) WITH READ ONLY

Columns