VIEW: APPS.OE_PRINT_SREP_PHONES_V

Source

View Text - Preformatted

SELECT jrs.salesrep_id, jre.category, hlk.lookup_code phone_code, hlk.meaning phone_meaning, pp.phone_number, pp.parent_id source_id from jtf_rs_salesreps jrs, jtf_rs_resource_extns jre, per_phones pp, hr_lookups hlk WHERE jrs.resource_id = jre.resource_id and jre.category = 'EMPLOYEE' and jre.source_id = pp.parent_id and pp.parent_table = 'PER_ALL_PEOPLE_F' and sysdate between pp.date_from and nvl(pp.date_to,sysdate) and hlk.lookup_type = 'PHONE_TYPE' and hlk.lookup_code IN ('M', 'O', 'P', 'W1', 'W2', 'W3', 'WF') and hlk.lookup_code = pp.phone_type

View Text - HTML Formatted

SELECT JRS.SALESREP_ID
, JRE.CATEGORY
, HLK.LOOKUP_CODE PHONE_CODE
, HLK.MEANING PHONE_MEANING
, PP.PHONE_NUMBER
, PP.PARENT_ID SOURCE_ID
FROM JTF_RS_SALESREPS JRS
, JTF_RS_RESOURCE_EXTNS JRE
, PER_PHONES PP
, HR_LOOKUPS HLK
WHERE JRS.RESOURCE_ID = JRE.RESOURCE_ID
AND JRE.CATEGORY = 'EMPLOYEE'
AND JRE.SOURCE_ID = PP.PARENT_ID
AND PP.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
AND SYSDATE BETWEEN PP.DATE_FROM
AND NVL(PP.DATE_TO
, SYSDATE)
AND HLK.LOOKUP_TYPE = 'PHONE_TYPE'
AND HLK.LOOKUP_CODE IN ('M'
, 'O'
, 'P'
, 'W1'
, 'W2'
, 'W3'
, 'WF')
AND HLK.LOOKUP_CODE = PP.PHONE_TYPE