VIEW: APPS.OTFV_PRICE_LIST_ENTRIES

Source

View Text - Preformatted

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 ,tvt.version_name activity_name ,tdt.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_versions_tl tvt ,ota_activity_definitions tad ,ota_activity_definitions_tl tdt 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_version_id = tvt.activity_version_id (+) AND tvt.language (+) = userenv('LANG') AND tav.activity_id = tad.activity_id (+) AND tad.activity_id = tdt.activity_id (+) AND tdt.language (+) = userenv('LANG') AND tpl.business_group_id = NVL(ota_general.get_business_group_id,tpl.business_group_id) WITH READ ONLY

View Text - HTML Formatted

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
, TVT.VERSION_NAME ACTIVITY_NAME
, TDT.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_VERSIONS_TL TVT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL TDT
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_VERSION_ID = TVT.ACTIVITY_VERSION_ID (+)
AND TVT.LANGUAGE (+) = USERENV('LANG')
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID (+)
AND TAD.ACTIVITY_ID = TDT.ACTIVITY_ID (+)
AND TDT.LANGUAGE (+) = USERENV('LANG')
AND TPL.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TPL.BUSINESS_GROUP_ID) WITH READ ONLY