VIEW: APPS.PA_RESOURCE_LISTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')