VIEW: APPS.WF_AMV_CHN_UR

Source

View Text - Preformatted

SELECT USR.USER_NAME, 'PER', PER.PERSON_ID, 'AMV_CHN'||':'||CHB.CHANNEL_ID, 'AMV_CHN', CHB.CHANNEL_ID, to_date(NULL), to_date(NULL), NULL, 6 from AMV_C_CHANNELS_B CHB, AMV_U_ACCESS CUA, JTF_RS_RESOURCE_EXTNS JRE, PER_ALL_PEOPLE_F PER, FND_USER USR WHERE CUA.ACCESS_TO_TABLE_CODE = 'CHANNEL' and CUA.ACCESS_TO_TABLE_RECORD_ID = CHB.CHANNEL_ID and CUA.USER_OR_GROUP_TYPE = 'USER' and CUA.EFFECTIVE_START_DATE <= sysdate and NVL(CUA.EXPIRATION_DATE,sysdate) >= sysdate and CUA.CHL_APPROVER_FLAG = 'T' and CUA.USER_OR_GROUP_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_CHN'||':'||CHB.CHANNEL_ID
, 'AMV_CHN'
, CHB.CHANNEL_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 6
FROM AMV_C_CHANNELS_B CHB
, AMV_U_ACCESS CUA
, JTF_RS_RESOURCE_EXTNS JRE
, PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE CUA.ACCESS_TO_TABLE_CODE = 'CHANNEL'
AND CUA.ACCESS_TO_TABLE_RECORD_ID = CHB.CHANNEL_ID
AND CUA.USER_OR_GROUP_TYPE = 'USER'
AND CUA.EFFECTIVE_START_DATE <= SYSDATE
AND NVL(CUA.EXPIRATION_DATE
, SYSDATE) >= SYSDATE
AND CUA.CHL_APPROVER_FLAG = 'T'
AND CUA.USER_OR_GROUP_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