MSC_DIM_SALES_ORG_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID ORG_RESOURCE_ID

Query

SQL_Statement
select org.sales_org_id id, org.sales_org_name name, org.parent_org_id parent_id, rep.sales_rep_id org_resource_id from msc_sales_org org , msc_sales_org_rep rep where org.sales_org_id = rep.parent_org_id