Product: | BIL - Sales Intelligence |
---|---|
Description: | Sales representative qualifications view |
Implementation/DBA Data: | APPS.BIL_DIMV_QUALIFICATIONS |
SELECT "PERSON_ID"
, "BUSINESS_GROUP_NAME"
, "PERSON_NAME"
, "QUALIFICATION_TITLE"
, "GRADE_ATTAINED"
, "QUALIFICATION_STATUS"
, "AWARDED_DATE"
, "FEE"
, "FEE_CURRENCY"
, "TRAINING_COMPLETED_AMOUNT"
, "REIMBURSEMENT_ARRANGEMENTS"
, "TOTAL_TRAINING_AMOUNT"
, "TRAINING_COMPLETED_UNITS"
, "QUALIFICATION_START_DATE"
, "QUALIFICATION_END_DATE"
, "LICENSE_NUMBER"
, "LICENSE_EXPIRY_DATE"
, "LICENSE_RESTRICTIONS"
, "PROJECTED_COMPLETION_DATE"
, "AWARDING_BODY"
, "METHOD_OF_REIMBURSEMENT"
, "GROUP_RANKING"
, "COMMENTS"
, "SCHOOL_OR_COLLEGE_NAME"
, "QUALIFICATION_CATEGORY"
, "QUALIFICATION_TYPE_NAME"
, "BUSINESS_GROUP_ID"
, "SCHOOL_OR_COLLEGE_ID"
, "QUALIFICATION_ID"
FROM HRFV_QUALIFICATIONS HQ
, BIL_DIMV_SALESFORCE BDS
WHERE HQ.PERSON_ID = BDS.EMPLOYEE_PERSON_FK
AND NVL(QUALIFICATION_START_DATE
, SYSDATE) <= SYSDATE
AND NVL(QUALIFICATION_END_DATE
, SYSDATE) >= SYSDATE UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) PERSON_ID
, SUBSTR(FL.MEANING
, 1
, 60) BUSINESS_GROUP_NAME
, FL.MEANING PERSON_NAME
, FL.MEANING QUALIFICATION_TITLE
, FL.MEANING GRADE_ATTAINED
, FL.MEANING QUALIFICATION_STATUS
, FL.END_DATE_ACTIVE AWARDED_DATE
, TO_NUMBER(FL.LOOKUP_CODE) FEE
, FL.MEANING FEE_CURRENCY
, TO_NUMBER(FL.LOOKUP_CODE) TRAINING_COMPLETED_AMOUNT
, FL.MEANING REIMBURSEMENT_ARRANGEMENTS
, TO_NUMBER(FL.LOOKUP_CODE) TOTAL_TRAINING_AMOUNT
, FL.MEANING TRAINING_COMPLETED_UNITS
, FL.START_DATE_ACTIVE QUALIFICATION_START_DATE
, FL.END_DATE_ACTIVE QUALIFICATION_END_DATE
, FL.MEANING LICENSE_NUMBER
, FL.END_DATE_ACTIVE LICENSE_EXPIRY_DATE
, FL.MEANING LICENSE_RESTRICTIONS
, FL.END_DATE_ACTIVE PROJECTED_COMPLETION_DATE
, FL.MEANING AWARDING_BODY
, FL.MEANING METHOD_OF_REIMBURSEMENT
, FL.MEANING GROUP_RANKING
, FL.DESCRIPTION COMMENTS
, FL.MEANING SCHOOL_OR_COLLEGE_NAME
, FL.MEANING QUALIFICATION_CATEGORY
, FL.MEANING QUALIFICATION_TYPE_NAME
, TO_NUMBER(FL.LOOKUP_CODE) BUSINESS_GROUP_ID
, TO_NUMBER(FL.LOOKUP_CODE) SCHOOL_OR_COLLEGE_ID
, TO_NUMBER(FL.LOOKUP_CODE) QUALIFICATION_ID
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY