nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

print bar code

SQLWrangler

Find more posts tagged with

Accepted answers

SQLWrangler

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 ppnf.effective_start_date AND ppnf.effective_end_date

All comments

Bhaskar Konar

Hi @SQLWrangler,

Welcome to the Oracle Analytics & AI Community!

Could you please share a bit more information about your issue or requirement? This will help us better understand your situation and, if needed, replicate it to find a potential resolution.

Thank you.

SQLWrangler

Bhashar,

Thank you for the response a colleague just got back to me with this solution querying ASCM tables and it works.

SQLWrangler

The last line may not be needed:

TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date