VIEW: APPS.BIL_DIMV_QUALIFICATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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