View: BIS_SALES_GROUPS_V

View Text

SELECT TO_CHAR(ASG.SALES_GROUP_ID) ID
, ASG.NAME VALUE
, FNUR.RESPONSIBILITY_ID
FROM AS_SALES_GROUPS ASG
, AS_SALESFORCE ASF
, FND_USER FNU
, FND_USER_RESP_GROUPS FNUR
WHERE ASG.SALES_GROUP_ID = ASF.SALES_GROUP_ID
AND ASF.EMPLOYEE_PERSON_ID = FNU.EMPLOYEE_ID
AND FNU.USER_ID = FND_PROFILE.VALUE_WNPS( 'USER_ID')
AND FNU.USER_ID = FNUR.USER_ID
AND NOT EXISTS ( SELECT 'Y'
FROM AS_SALES_GROUPS ASG1
WHERE ASG1.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN ASG1.START_DATE_ACTIVE
AND NVL(ASG1.END_DATE_ACTIVE
, SYSDATE )
AND ASG1.MANAGER_PERSON_ID = ASF.EMPLOYEE_PERSON_ID ) UNION SELECT TO_CHAR(ASMGR.SALES_GROUP_ID )
, ASMGR.NAME VALUE
, FNUR2.RESPONSIBILITY_ID
FROM AS_SALES_GROUPS ASMGR
, FND_USER FNU
, FND_USER_RESP_GROUPS FNUR2
WHERE ASMGR.MANAGER_PERSON_ID = FNU.EMPLOYEE_ID
AND ASMGR.ENABLED_FLAG = 'Y'
AND TRUNC( SYSDATE) BETWEEN ASMGR.START_DATE_ACTIVE
AND NVL( ASMGR.END_DATE_ACTIVE
, SYSDATE )
AND FNU.USER_ID = FND_PROFILE.VALUE_WNPS( 'USER_ID')
AND FNU.USER_ID = FNUR2.USER_ID

Columns