Welcome to the Oracle Analytics and AI Community

Home› SQLWrangler› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SQLWrangler Rank 1 - Community Starter

Comments

  • The last line may not be needed: TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
    in print bar code Comment by SQLWrangler 6:36PM
  • Bhashar, Thank you for the response a colleague just got back to me with this solution querying ASCM tables and it works. SELECT ppnf.full_nameFROM per_users pu,per_person_names_f ppnfWHERE pu.username = fnd_global.user_nameAND pu.person_id = ppnf.person_idAND UPPER(ppnf.name_type) = 'GLOBAL'AND TRUNC(SYSDATE) BETWEEN…
    in print bar code Comment by SQLWrangler 6:34PM