Product: | PA - Projects |
---|---|
Description: | Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. |
Implementation/DBA Data: | APPS.PA_RESOURCE_LISTS |
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')