Wednesday, 23 August 2017

Query to get profile options details from backend

SELECT
  fpov.profile_option_name ,
  fpov.user_profile_option_name,
  DECODE (TO_CHAR (fpo.level_id), '10001', 'SITE', '10002', 'APP', '10003',
  'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', 'NA' )
  profile_Level,
  DECODE (TO_CHAR (fpo.level_id), '10001', '', '10002',
  fa.application_short_name, '10003', fr.responsibility_key, '10005',
  fn.node_name, '10006', hou.NAME, '10004', fu.user_name, 'NA' ) Context_value,
  fpo.profile_option_value value,
  fr.RESPONSIBILITY_KEY,
  fr.RESPONSIBILITY_NAME
FROM
  apps.fnd_profile_options_vl fpov,
  apps.fnd_profile_option_values fpo,
  apps.fnd_user fu,
  apps.fnd_application fa,
  apps.fnd_responsibility_vl fr,
  apps.fnd_nodes fn,
  apps.hr_operating_units hou
WHERE
  1                         = 1
AND fpo.application_id      = fpov.application_id
AND fpo.profile_option_id   = fpov.profile_option_id
AND fu.user_id(+)           = fpo.level_value
AND fr.application_id(+)    = fpo.level_value_application_id
AND fr.responsibility_id(+) = fpo.level_value
AND fa.application_id(+)    = fpo.level_value
AND fn.node_id(+)           = fpo.level_value
AND hou.organization_id(+)  = fpo.level_value
AND fpov.user_profile_option_name LIKE 'GL: Data Access Set%' ;

No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...