1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_REP_RESOURCE_V

FFS_REP_RESOURCE_V

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: VIEW

Columns

Name

NEXT_OWNER_ID

NEXT_OWNER_NAME

PARENT_ID

CHILD_ID

NAME

TYPE

ACTIVE

DISTANCE

RESOURCE_ID

Query

SQL_Statement

SELECT

resource_next_owner.resource_id AS next_owner_id,

resource_next_owner.name AS next_owner_name,

ffs_resource_hierarchy.parent_id,

ffs_resource_hierarchy.child_id,

ffs_resource.name,

ffs_resource.type,

ffs_resource.active,

ffs_resource_hierarchy.distance,

ffs_resource_hierarchy.child_id AS resource_id

FROM

ffs_resource_hierarchy,

ffs_resource ffs_resource,

ffs_resource resource_owner,

ffs_resource resource_next_owner

WHERE

ffs_resource.resource_id = ffs_resource_hierarchy.child_id

AND resource_owner.resource_id = ffs_resource_hierarchy.parent_id

AND resource_next_owner.resource_id = (

CASE WHEN distance=1 THEN

ffs_resource_hierarchy.child_id

ELSE

(

SELECT parent_id from ffs_resource_hierarchy rh where

rh.child_id = ffs_resource_hierarchy.child_id and rh.distance =ffs_resource_hierarchy.distance - 1 and rownum<2)

END

)