VIEW: APPS.PA_RESOURCE_LISTS

Source

View Text - Preformatted

SELECT R.RESOURCE_LIST_ID ,RTL.NAME ,RTL.DESCRIPTION ,R.PUBLIC_FLAG ,R.GROUP_RESOURCE_TYPE_ID ,R.START_DATE_ACTIVE ,R.END_DATE_ACTIVE ,R.UNCATEGORIZED_FLAG ,R.LAST_UPDATED_BY ,R.LAST_UPDATE_DATE ,R.CREATION_DATE ,R.CREATED_BY ,R.LAST_UPDATE_LOGIN ,R.BUSINESS_GROUP_ID ,R.adw_notify_flag ,R.job_group_id ,R.resource_list_type ,R.CONTROL_FLAG ,R.USE_FOR_WP_FLAG ,R.MIGRATION_CODE ,R.RECORD_VERSION_NUMBER ,R.MIGRATED_RBS_VERSION_ID FROM PA_RESOURCE_LISTS_ALL_BG R , pa_resource_lists_tl RTL WHERE ((R.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') and pa_cross_business_grp.IsCrossBGProfile='N') OR pa_cross_business_grp.IsCrossBGProfile ='Y') AND RTL.resource_list_id = r.resource_list_id AND RTL.language = userenv('LANG')

View Text - HTML Formatted

SELECT R.RESOURCE_LIST_ID
, RTL.NAME
, RTL.DESCRIPTION
, R.PUBLIC_FLAG
, R.GROUP_RESOURCE_TYPE_ID
, R.START_DATE_ACTIVE
, R.END_DATE_ACTIVE
, R.UNCATEGORIZED_FLAG
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.BUSINESS_GROUP_ID
, R.ADW_NOTIFY_FLAG
, R.JOB_GROUP_ID
, R.RESOURCE_LIST_TYPE
, R.CONTROL_FLAG
, R.USE_FOR_WP_FLAG
, R.MIGRATION_CODE
, R.RECORD_VERSION_NUMBER
, R.MIGRATED_RBS_VERSION_ID
FROM PA_RESOURCE_LISTS_ALL_BG R
, PA_RESOURCE_LISTS_TL RTL
WHERE ((R.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')
AND RTL.RESOURCE_LIST_ID = R.RESOURCE_LIST_ID
AND RTL.LANGUAGE = USERENV('LANG')