Crontab

DATE=$(date +"%d%m%y")

export ORACLE_SID=

export ORACLE_HOME=/oracle/product/database/10.2.0/PMIS


export PATH=/oracle/product/database/10.2.0/PMIS/bin


exp pmis/ file=/scaned-images/exp_pmis_$DATE.dmp log=/scaned-images/exp_pmis_$DATE.log statistics=none

find -H /export/home/Backup/ . -type f -name "*.dmp" -print -exec gzip {} \;

user_responsiblity_apps

SELECT fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
furg.start_date "Start Date",
furg.end_date "End Date",
fr.responsibility_key "Responsibility Key",
fa.application_short_name "Application Short Name"
FROM fnd_user_resp_groups_direct furg,
applsys.fnd_user fu,
applsys.fnd_responsibility_tl frt,
applsys.fnd_responsibility fr,
applsys.fnd_application_tl fat,
applsys.fnd_application fa
WHERE furg.user_id = fu.user_id
AND furg.responsibility_id = frt.responsibility_id
AND fr.responsibility_id = frt.responsibility_id
AND fa.application_id = fat.application_id
AND fr.application_id = fat.application_id
AND frt.language = USERENV('LANG')
-- AND UPPER(fu.user_name) = UPPER('AMOHSIN') --
-- AND (furg.end_date IS NULL OR furg.end_date >= TRUNC(SYSDATE))
ORDER BY frt.responsibility_name;


-------------
select u.user_name, a.application_name, r.responsibility_name, r.responsibility_id, wu.end_date
from apps.fnd_user u, apps.fnd_responsibility_tl r, apps.fnd_application_tl a, apps.wf_local_roles ur,
apps.wf_user_role_assignments wu
where u.user_name=wu.user_name and wu.role_name=ur.name
and ur.display_name=r.responsibility_name
and a.application_id=r.application_id
--and wu.user_name='RBEHARI'
and
(wu.end_date is null or wu.end_date >= sysdate) and
a.language='US'
order by u.user_name, r.responsibility_name

--------------------

SELECT
fuser.USER_NAME USER_NAME
, per.FULL_NAME FULL_NAME
, per.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, frt.RESPONSIBILITY_NAME RESPONSIBILITY
FROM
FND_USER fuser
, PER_PEOPLE_F per
, FND_USER_RESP_GROUPS furg
, FND_RESPONSIBILITY_TL frt
WHERE
fuser.EMPLOYEE_ID = per.PERSON_ID
AND fuser.USER_ID = furg.USER_ID
AND (to_char(fuser.END_DATE) is null
OR fuser.END_DATE > sysdate)
AND frt.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID
AND (to_char(furg.END_DATE) is null
OR furg.END_DATE > sysdate)
AND frt.LANGUAGE = 'US'
ORDER BY
fuser.USER_NAME;

--------------