DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on CSF_SELECTED_RESOURCES_V

Line 283: FROM CSF_SELECTED_RESOURCES_V

279: FROM (
280: SELECT RESOURCE_NAME,
281: RESOURCE_ID,
282: RESOURCE_TYPE
283: FROM CSF_SELECTED_RESOURCES_V
284: MINUS
285: SELECT DISTINCT
286: A.RESOURCE_NAME ,
287: A.RESOURCE_ID ,

Line 289: FROM CSF_SELECTED_RESOURCES_V A,

285: SELECT DISTINCT
286: A.RESOURCE_NAME ,
287: A.RESOURCE_ID ,
288: A.RESOURCE_TYPE
289: FROM CSF_SELECTED_RESOURCES_V A,
290: JTF_RS_DEFRESROLES_VL B,
291: JTF_RS_ALL_RESOURCES_VL C,
292: JTF_RS_ROLES_B D
293: WHERE B.ROLE_RESOURCE_ID=A.RESOURCE_ID

Line 316: FROM CSF_SELECTED_RESOURCES_V RES ,

312: SELECT DISTINCT
313: RES.RESOURCE_NAME,
314: RES.RESOURCE_ID,
315: RES.RESOURCE_TYPE
316: FROM CSF_SELECTED_RESOURCES_V RES ,
317: JTF_RS_ROLE_RELATIONS RR,
318: JTF_RS_ROLES_B RL ,
319: FND_LOOKUPS LKP
320: WHERE RR.ROLE_ID = RL.ROLE_ID

Line 333: FROM CSF_SELECTED_RESOURCES_V A,

329: SELECT DISTINCT
330: A.RESOURCE_NAME,
331: A.RESOURCE_ID ,
332: A.RESOURCE_TYPE
333: FROM CSF_SELECTED_RESOURCES_V A,
334: JTF_RS_ROLE_RELATIONS RR,
335: JTF_RS_ROLES_B RL ,
336: FND_LOOKUPS LKP
337: WHERE RR.ROLE_RESOURCE_ID = A.RESOURCE_ID