VIEW: APPS.PA_PLANNING_RESOURCES_V

Source

View Text - Preformatted

SELECT rl.resource_list_id resource_list_id, rlm.resource_list_member_id resource_list_member_id, rlm.alias planning_resource_alias, rlm.res_format_id, rf.name, pa_planning_resource_utils.get_plan_res_combination(rlm.resource_list_member_id) planning_resource_combination, rlm.resource_class_id resource_class_id, rlm.resource_class_code resource_class_code, rc.name resource_class_name, rlm.unit_of_measure, rlm.object_type, rlm.object_id from pa_resource_lists_all_bg rl , pa_resource_list_members rlm , pa_resource_classes_vl rc , pa_res_formats_vl rf WHERE rl.migration_code IS NOT NULL and rl.resource_list_id = rlm.resource_list_id and rlm.migration_code IS NOT NULL and rlm.enabled_flag = 'Y' and rlm.resource_class_id = rc.resource_class_id and rlm.res_format_id = rf.res_format_id

View Text - HTML Formatted

SELECT RL.RESOURCE_LIST_ID RESOURCE_LIST_ID
, RLM.RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS PLANNING_RESOURCE_ALIAS
, RLM.RES_FORMAT_ID
, RF.NAME
, PA_PLANNING_RESOURCE_UTILS.GET_PLAN_RES_COMBINATION(RLM.RESOURCE_LIST_MEMBER_ID) PLANNING_RESOURCE_COMBINATION
, RLM.RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, RLM.RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, RC.NAME RESOURCE_CLASS_NAME
, RLM.UNIT_OF_MEASURE
, RLM.OBJECT_TYPE
, RLM.OBJECT_ID
FROM PA_RESOURCE_LISTS_ALL_BG RL
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_CLASSES_VL RC
, PA_RES_FORMATS_VL RF
WHERE RL.MIGRATION_CODE IS NOT NULL
AND RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID
AND RLM.MIGRATION_CODE IS NOT NULL
AND RLM.ENABLED_FLAG = 'Y'
AND RLM.RESOURCE_CLASS_ID = RC.RESOURCE_CLASS_ID
AND RLM.RES_FORMAT_ID = RF.RES_FORMAT_ID