[Home] [Help]
83: CURSOR C_Terr_Resource
84: IS SELECT DISTINCT TR.RESOURCE_ID RESOURCE_ID,
85: TR.RESOURCE_TYPE RESOURCE_TYPE,
86: TR.RESOURCE_NAME RESOURCE_NAME,
87: CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME( TR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME,
88: TR.RESOURCE_ID||'-'||TR.RESOURCE_TYPE
89: FROM CSF_SELECTED_RESOURCES_V TR
90: ORDER BY UPPER(TR.RESOURCE_NAME);
91: