[Home] [Help]
View: OE_PRINT_SREP_PHONES_V
View Text
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
Columns
Name |
SALESREP_ID |
CATEGORY |
PHONE_CODE |
PHONE_MEANING |
PHONE_NUMBER |
SOURCE_ID |