1. Tables and Views for SCM
  2. MSC_AP_SALES_REP_V

MSC_AP_SALES_REP_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

RESOURCE_NAME

SOURCE_RESOURCE_ID

PARENT_SOURCE_RES_ID

PARENT_ORG_ID

PARENT_ORG_NAME

Query

SQL_Statement

SELECT p.person_name resource_name,

r.resource_id source_resource_id,

r.parent_resource_id parent_source_res_id,

r.parent_org_id Parent_org_id,

h.name Parent_org_name

FROM jtf_rs_rep_managers r ,

jtf_rs_resource_profiles p,

fnd_tree_version tv ,

HR_ALL_ORGANIZATION_UNITS_VL h,

JTF_RS_ROLE_RELATIONS role,

jtf_rs_roles_b roleb

WHERE r.tree_structure_code =tv.tree_structure_code

AND r.tree_version_id = tv.tree_version_id

AND r.tree_code = tv.tree_code

AND tv.tree_structure_code = 'RESOURCE_ORG_TREE_STRUCTURE'

AND TRUNC(sysdate) BETWEEN TRUNC(tv.effective_start_date) AND

TRUNC(tv.effective_end_date)

AND TRUNC(sysdate) BETWEEN TRUNC(p.start_date_active) AND

TRUNC(p.end_date_active)

AND p.party_id = r.resource_id

and r.parent_org_id = h.organization_id

and r.resource_id = r.parent_resource_id

and r.resource_id=role.role_resource_id

and role.role_id=roleb.role_id and

roleb. ROLE_CODE='SALES_REPRESENTATIVE' and roleb.ROLE_TYPE_CODE='SALES'