You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Learning assignment SQL query for OLC

    edited Aug 7, 2020 9:25PM in Learning 2 comments

    Summary

    Query of learning assignment

    Content

    Hi Eveyrone,

    Is anyone provide me the query fOR Learning assignment.

    Please find below query which i used but getting duplicate data:

    SELECT 
    DISTINCT 
     WEL.NAME NAME
    ,WEAF.COMMENTS WITH_THIS_NOTE
    ,WEA.ASSIGNMENT_RECORD_NUMBER ASSIGNMENT_PROFILE_NUMBER
    ,WEL.DESCRIPTION
     
    ,NVL(TO_CHAR(WEA.EFFECTIVE_START_DATE, 'MM/DD/YYYY'), ' ') START_DATE
    ,NVL(TO_CHAR(WEA.WITHDRAWN_DATE, 'MM/DD/YYYY'), ' ') WITHDRAWN_DATE
    ,NVL(TO_CHAR(WEA.EFFECTIVE_END_DATE, 'MM/DD/YYYY'), ' ') INITIATIVE_END_DATE
    ,WAR.NAME ASSIGN
     
    ,(SELECT NVL(FLVV.MEANING,' ')
    FROM FND_LOOKUP_VALUES_VL FLVV
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!