MSC_DIM_SALES_REP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID

Query

SQL_Statement

SELECT ID,NAME,MAX(PARENT_ID) PARENT_ID FROM(select sales_rep_id id, sales_rep_name name, parent_org_id parent_id from msc_sales_org_rep union all SELECT SHTL.ID ID, SHTL.NAME NAME, LLMD.ID parent_id FROM MSC_DIM_CSTMHRCHY_LLMD LLMD, MSC_DIM_CSTMHRCHY_SHTL SHTL WHERE LLMD.HIERARCHY_ID = SHTL.HIERARCHY_ID AND SHTL.LEVEL_ID = 103 AND LLMD.LEVEL_ID = SHTL.PARENT_LEVEL_ID AND LLMD.ID = SHTL.PARENT_ID AND NOT EXISTS (select 1 from msc_sales_org_rep MSOR WHERE MSOR.sales_rep_id = SHTL.ID)) GROUP BY ID,NAME