Monday, October 23, 2017

Query to get all Inactive Users and thier Inactive Responsibilities in Oracle 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 (furg.end_date <= TRUNC(SYSDATE))
       AND (TRUNC(fu.end_date) <= TRUNC(SYSDATE))
  ORDER BY fu.user_name;

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)