VIEW: APPS.CSF_M_EMPLOYEES_V

Source

View Text - Preformatted

SELECT res_acc.access_id, res.resource_id, res.resource_number, people.person_id, source_name AS full_name, fnd_user.user_name as username, decode(fnd_user.user_name,asg_base.get_user_name, asg_base.get_language, null) as language, asg_base.get_user_name as mobile_name, csm_profile_pkg.get_org_id(asg_base.get_user_id) as org_id, csm_profile_pkg.get_organization_id(asg_base.get_user_id) as organization_id, res.user_id from jtf_rs_resource_extns res, csm_rs_resource_extns_acc res_acc, fnd_user, per_all_people_f people WHERE res_acc.user_id = asg_base.get_user_id and res.resource_id = res_acc.resource_id and res.category = 'EMPLOYEE' and res.user_id = FND_USER.user_id and people.person_id = res.source_id AND (SYSDATE BETWEEN people.effective_start_date AND people.effective_end_date)

View Text - HTML Formatted

SELECT RES_ACC.ACCESS_ID
, RES.RESOURCE_ID
, RES.RESOURCE_NUMBER
, PEOPLE.PERSON_ID
, SOURCE_NAME AS FULL_NAME
, FND_USER.USER_NAME AS USERNAME
, DECODE(FND_USER.USER_NAME
, ASG_BASE.GET_USER_NAME
, ASG_BASE.GET_LANGUAGE
, NULL) AS LANGUAGE
, ASG_BASE.GET_USER_NAME AS MOBILE_NAME
, CSM_PROFILE_PKG.GET_ORG_ID(ASG_BASE.GET_USER_ID) AS ORG_ID
, CSM_PROFILE_PKG.GET_ORGANIZATION_ID(ASG_BASE.GET_USER_ID) AS ORGANIZATION_ID
, RES.USER_ID
FROM JTF_RS_RESOURCE_EXTNS RES
, CSM_RS_RESOURCE_EXTNS_ACC RES_ACC
, FND_USER
, PER_ALL_PEOPLE_F PEOPLE
WHERE RES_ACC.USER_ID = ASG_BASE.GET_USER_ID
AND RES.RESOURCE_ID = RES_ACC.RESOURCE_ID
AND RES.CATEGORY = 'EMPLOYEE'
AND RES.USER_ID = FND_USER.USER_ID
AND PEOPLE.PERSON_ID = RES.SOURCE_ID
AND (SYSDATE BETWEEN PEOPLE.EFFECTIVE_START_DATE
AND PEOPLE.EFFECTIVE_END_DATE)