VIEW: APPS.OTFV_PRICE_LISTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,tpl.name price_list_name ,tpl.comments price_list_comments ,tpl.description description ,ota_general.fnd_currency_name(tpl.currency_code) currency ,hr_bis.bis_decode_lookup('YES_NO',tpl.default_flag) deafult_price_list ,tpl.start_date price_list_start_date ,tpl.end_date price_list_end_date ,hr_bis.bis_decode_lookup('PRICE_LIST_TYPE',tpl.price_list_type) price_list_type ,tpl.single_unit_price unit_price ,tpl.training_unit_type training_unit ,'_DF:OTA:OTA_PRICE_LISTS:tpl' ,tpl.price_list_id price_list_id ,tpl.business_group_id business_group_id FROM ota_price_lists tpl ,hr_all_organization_units_tl bgrT WHERE bgrT.organization_id = tpl.business_group_id AND bgrT.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
, TPL.NAME PRICE_LIST_NAME
, TPL.COMMENTS PRICE_LIST_COMMENTS
, TPL.DESCRIPTION DESCRIPTION
, OTA_GENERAL.FND_CURRENCY_NAME(TPL.CURRENCY_CODE) CURRENCY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TPL.DEFAULT_FLAG) DEAFULT_PRICE_LIST
, TPL.START_DATE PRICE_LIST_START_DATE
, TPL.END_DATE PRICE_LIST_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('PRICE_LIST_TYPE'
, TPL.PRICE_LIST_TYPE) PRICE_LIST_TYPE
, TPL.SINGLE_UNIT_PRICE UNIT_PRICE
, TPL.TRAINING_UNIT_TYPE TRAINING_UNIT
, '_DF:OTA:OTA_PRICE_LISTS:TPL'
, TPL.PRICE_LIST_ID PRICE_LIST_ID
, TPL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM OTA_PRICE_LISTS TPL
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE BGRT.ORGANIZATION_ID = TPL.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TPL.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TPL.BUSINESS_GROUP_ID) WITH READ ONLY