View: BIL_DIMV_JOB_TITLE

Product:	BIL - Sales Intelligence
Description:	Sales representatives job tiles view
Implementation/DBA Data:	APPS.BIL_DIMV_JOB_TITLE

View Text

SELECT DISTINCT PAAF.JOB_ID
, PAAF.TITLE
, TO_CHAR(PAAF.JOB_ID) ID
, PAAF.TITLE VALUE
FROM PER_ALL_ASSIGNMENTS_F PAAF
WHERE PAAF.TITLE IS NOT NULL
AND PAAF.PRIMARY_FLAG = 'Y' UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) JOB_PK
, SUBSTR(FL.MEANING
, 1
, 30) JOB_TITLE
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns