Monday, October 23, 2017

Query to find Responsibilities Assigned to a Particular User in Oracle Applications

SELECT fu.user_id,
       fu.user_name,
       fur.responsibility_id,
       fr.responsibility_name
  FROM fnd_user fu, fnd_user_resp_groups fur
      ,fnd_responsibility_vl fr
 WHERE fu.user_id = fur.user_id
   AND fr.application_id = fur.responsibility_application_id
   AND fr.responsibility_id = fur.responsibility_id
   AND TRUNC (SYSDATE) BETWEEN TRUNC (fr.start_date)
                           AND TRUNC (NVL ( (fr.end_date - 1), SYSDATE))
   AND TRUNC (SYSDATE) BETWEEN TRUNC (fur.start_date)
                           AND TRUNC (NVL ( (fur.end_date - 1), SYSDATE))
   AND user_name LIKE '<<GIVE USER_NAME>>'
order by 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)