FFS_REP_ROUTE_V

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ROUTE_DATE ROUTE_ID ROUTE_ACTIVATED RESOURCE_ID RESOURCE_EXT_ID RESOURCE_PARENT

Query

SQL_Statement
SELECT rt.route_date, rt.route_id, rt.activated AS route_activated, rs.resource_id, rs.external_id AS resource_ext_id, rs.parent AS resource_parent FROM ffs_route rt JOIN ffs_resource rs ON rt.resource_id = rs.resource_id