fnd_user_resp_groups_direct table query
I am trying to write an SQL query to pull out users and their responsibilities in one master report, rather than having to run endless reports in the application itself.
I noticed in fnd_user_resp_groups_direct there is a start_date and end_date column. This table (could be a view actually) joins to fnd_user on user_id column. Does the start_date and end_date column in the fnd_user_resp_groups_direct table represent the start and end date that user was granted the responsibility, and the responsibility removed from the user, respectively, or if not - what do the start and end dates represent in that table. If it is a view, I would like to see which table its pulling those fields from, and the question remains - what do they represent.