VIEW: APPS.WF_AMV_APPR_UR

Source

View Text - Preformatted

SELECT USR.USER_NAME, 'PER', PER.PERSON_ID, 'AMV_APPR', 'AMV_APPR', 520, to_date(NULL), to_date(NULL), NULL, 5 from JTF_RS_ROLES_B JRB, JTF_RS_ROLE_RELATIONS JRR, JTF_RS_RESOURCE_EXTNS JRE, PER_ALL_PEOPLE_F PER, FND_USER USR WHERE JRB.ROLE_TYPE_CODE = 'MES' and JRB.ROLE_CODE = 'MES_APPROVE' and JRB.ROLE_ID = JRR.ROLE_ID and JRR.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL' and JRR.ROLE_RESOURCE_ID = JRE.RESOURCE_ID and JRE.CATEGORY = 'EMPLOYEE' and JRE.SOURCE_ID = PER.PERSON_ID and trunc(SYSDATE) between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE and PER.PERSON_ID = USR.EMPLOYEE_ID union select USR.USER_NAME, 'PER', PER.PERSON_ID, 'AMV_APPR', 'AMV_APPR', 520, to_date(NULL), to_date(NULL), NULL, 5 from JTF_RS_ROLES_B JRB, JTF_RS_ROLE_RELATIONS JRR, JTF_RS_GROUP_USAGES JGU, JTF_RS_GROUPS_B JGB, JTF_RS_GROUP_MEMBERS JGM, JTF_RS_RESOURCE_EXTNS JRE, PER_ALL_PEOPLE_F PER, FND_USER USR where JRB.ROLE_TYPE_CODE = 'MES' and JRB.ROLE_CODE = 'MES_APPROVE' and JRB.ROLE_ID = JRR.ROLE_ID and JRR.ROLE_RESOURCE_TYPE = 'RS_GROUP' and JRR.ROLE_RESOURCE_ID = JGB.GROUP_ID and NVL(JRR.DELETE_FLAG,'N') <> 'Y' and JGU.USAGE = 'MES_GROUP' and JGU.GROUP_ID = JGB.GROUP_ID and JGU.GROUP_ID = JRR.ROLE_RESOURCE_ID and JGB.GROUP_ID = JGM.GROUP_ID and NVL(JGM.DELETE_FLAG,'N') <> 'Y' and JGM.RESOURCE_ID = JRE.RESOURCE_ID and JRE.CATEGORY = 'EMPLOYEE' and JRE.SOURCE_ID = PER.PERSON_ID and trunc(SYSDATE) between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE and PER.PERSON_ID = USR.EMPLOYEE_ID

View Text - HTML Formatted

SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'AMV_APPR'
, 'AMV_APPR'
, 520
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 5
FROM JTF_RS_ROLES_B JRB
, JTF_RS_ROLE_RELATIONS JRR
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE JRB.ROLE_TYPE_CODE = 'MES'
AND JRB.ROLE_CODE = 'MES_APPROVE'
AND JRB.ROLE_ID = JRR.ROLE_ID
AND JRR.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'
AND JRR.ROLE_RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = USR.EMPLOYEE_ID UNION SELECT USR.USER_NAME
, 'PER'
, PER.PERSON_ID
, 'AMV_APPR'
, 'AMV_APPR'
, 520
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 5
FROM JTF_RS_ROLES_B JRB
, JTF_RS_ROLE_RELATIONS JRR
, JTF_RS_GROUP_USAGES JGU
, JTF_RS_GROUPS_B JGB
, JTF_RS_GROUP_MEMBERS JGM
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE JRB.ROLE_TYPE_CODE = 'MES'
AND JRB.ROLE_CODE = 'MES_APPROVE'
AND JRB.ROLE_ID = JRR.ROLE_ID
AND JRR.ROLE_RESOURCE_TYPE = 'RS_GROUP'
AND JRR.ROLE_RESOURCE_ID = JGB.GROUP_ID
AND NVL(JRR.DELETE_FLAG
, 'N') <> 'Y'
AND JGU.USAGE = 'MES_GROUP'
AND JGU.GROUP_ID = JGB.GROUP_ID
AND JGU.GROUP_ID = JRR.ROLE_RESOURCE_ID
AND JGB.GROUP_ID = JGM.GROUP_ID
AND NVL(JGM.DELETE_FLAG
, 'N') <> 'Y'
AND JGM.RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = USR.EMPLOYEE_ID