[Home] [Help]
View: PO_BUYERS_ALL_V
View Text
SELECT PRF.FULL_NAME
, NVL(PRF.EMPLOYEE_NUMBER
, PRF.NPW_NUMBER)
, PRF.PERSON_ID
, PBG.NAME
FROM PER_PEOPLE_F PRF
, PO_AGENTS POA
, PER_BUSINESS_GROUPS_PERF PBG
WHERE PRF.PERSON_ID = POA.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN PRF.EFFECTIVE_START_DATE
AND PRF.EFFECTIVE_END_DATE
AND PRF.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID
Columns
Name |
FULL_NAME |
EMPLOYEE_NUM |
EMPLOYEE_ID |
BG_NAME |