View: PA_RESOURCE_LISTS_V

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_V

View Text

SELECT ROW_ID
, RESOURCE_LIST_ID
, NAME
, DESCRIPTION
, PUBLIC_FLAG
, GROUP_RESOURCE_TYPE_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, UNCATEGORIZED_FLAG
, MIGRATION_CODE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID
, ADW_NOTIFY_FLAG
, JOB_GROUP_ID
, RESOURCE_LIST_TYPE
FROM PA_RESOURCE_LISTS_VL
WHERE ((BUSINESS_GROUP_ID = PA_UTILS.BUSINESS_GROUP_ID
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')

Columns