ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35CE578C93AF8577E06362FB0905F9F4 select null action_, null status_, null message_, null modified_columns_, xue.rowid row_id_, xue.* from xxen_upload_example xue where 1=1 Y U I xxen_upload_example US ashish test 030625-int 1=1 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 5 ROW_ID_ Rowid rowid 6 ID Number number 7 NAME LOV custom varchar2 select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name Ashish Test Comment Y 8 DATE_OF_BIRTH Date date 9 CREATED_BY Number number 10 CREATION_DATE Date date 11 LAST_UPDATED_BY Number number 12 LAST_UPDATE_DATE Date date U 1 id Number ID U 2 name Char NAME U 3 date_of_birth Date DATE_OF_BIRTH U 4 created_by Number CREATED_BY U 5 creation_date Date CREATION_DATE U 6 last_updated_by Number LAST_UPDATED_BY U 7 last_update_date Date LAST_UPDATE_DATE Error SQL select xue.action_, xue.status_, xue.message_, xue.modified_columns_, xue.row_id_, xue.id, xue.name, xue.date_of_birth, xue.created_by, xue.creation_date, xue.last_updated_by, xue.last_update_date from xxen_ashish_test_030625_7590_u xue where xue.status_code_=xxen_upload.status_error Success SQL select xue.action_, xue.status_, xue.message_, xue.modified_columns_, xue.row_id_, xue.id, xue.name, xue.date_of_birth, xue.created_by, xue.creation_date, xue.last_updated_by, xue.last_update_date from xxen_ashish_test_030625_7590_u xue where xue.status_code_=xxen_upload.status_success