Script to check Responsibilities assigned to particular user or users assigned for particular responsibility or all users and their responsibilities

Script to check Responsibilities assigned to particular user

or users assigned for particular responsibility

or all users and their responsibilities in oracle

  SELECT fu.user_id,

         fu.user_name,

         fur.responsibility_id,

         fr.responsibility_name

    FROM APPS.fnd_user fu,

         apps.fnd_user_resp_groups fur,

         apps.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 UPPER ( :p_user_name) --- for all user or for perticular user

        -- AND fur.responsibility_application_id = 275 -- to check users for perticular responsibility

ORDER BY user_name

Oracle Apps Standard moduls interface and base tables list

Oracle Apps Standard modules interface and base tables list

Module	Interface tables		Base tables
GL	GL Tables
GL	gl_interface		gl_je_batches
GL	gl_budget_interface		gl_je_headers
GL	GL_DAILY_RATES_INTERFACE		gl_je_lines
GL			gl_je_sources
GL			gl_je_categories
GL			gl_je_ledgers
GL			gl_daily_rates
GL			gl_balances
GL			gl_periods
GL			gl_period_sets
GL			gl_code_combinations
Module	Interface tables		Base tables
AP	AP_INVOICES TABLES
AP	ap_invoices_interface		ap_invoices_all
AP	ap_invoice_lines_interface		ap_invoice_lines_all
AP			ap_invoice_distributions_all
AP			ap_payments_schedules_all
AP			ap_invoice_payments_all
AP	AP_SUPPLIERS TABLES
AP	AP_SUPPILERS_INT		AP_SUPPLIERS
AP	AP_SUPPLIER_SITES_INT		AP_SUPPLIER_SITES_ALL
AP	AP_SUP_SITE_CONTACTS_INT		AP_SUPPLIER_CONTACTS
Module	Interface tables		Base tables
FA	FA TABLES
FA	fa_inv_interfce		fa_additions_b
FA	fa_production_interface		fa_additions_tl
FA	fa_mass_additions		fa_books
FA			fa_deprn_summary
FA			fa_deprn_details
FA			fa_deprn_history
FA			fa_retirements
Module	Interface tables	Base tables
AR	RA_CUSTOMERS TABLES	===========
AR	ra_customers_interface_all	hz_parties
AR	ra_contact_phones_int_all	hz_cust_accounts
AR	ra_customer_profiles_int_all	hz_cust_acct_sites_all
AR		hz_party_sites
AR		hz_locations
AR		hz_party_sites
AR		hz_locations
AR		hz_party_site_uses
AR		hz_customer_profiles
AR		hz_organization_profiles
AR		hz_person_profiles
Module	Interface tables	Base tables
AR	RA_INVOICES TABLES	===========
AR	ra_interface_lines_all	ra_customer_trx_all
AR	ra_interface_distributions_all	ra_customer_trx_lines_all
AR	ra_interface_salescredits_all	ra_cust_trx_line_gl_dist_all
AR		ra_cust_trx_types_all
AR		ar_payment_schedules_all
AR		ra_batch_sources_all
AR		ar_vat_tax_all
AR		ra_terms
AR		ar_periods
AR		ar_period_types
Module	Interface tables	Base tables
PO	PO REUISITION TABLES	===========
PO	po_reuisitions_interface_all	PO_REQUISITION_HEADERS_ALL
PO	po_re_dist_interace_all	PO_REQUISITION_LINES_ALL
PO		PO_REQ_DISTRIBUTIONS_ALL
PO	PO PURCASING TABLES	===========
PO	po_headers_interface	po_headers_all
PO	po_lines_interface	po_lines_all
PO	po_distributions_interface	po_line_locations_all
PO		po_distributions_all
Module	Interface tables	Base tables
PO	PO VENDORS TABLES	===========
PO		po_vendors
PO		po_vendor_sites_all
PO		po_vendor_site_contacts
Module	Interface tables		Base tables
OE	OM SALES ORDER		===========
OE	oe_headers_iface_all		or_order_headers_all
OE	oe_lines_iface_all		or_order_lines_all
OE	oe_actions_iface_all		or_order_sources
OE			oe_transactions_types_tl
OE			oe_transactions_types_all
Module	Interface tables		Base tables
INV	INV MODULE
	mtl_sustem_intems_interface		mtl_system_items_b
	mtl_item_categories_interface		mtl_sustem_item_tl
	mtl_item_revision_interface		mtl_item_locations
	mtl_interface_errors		mtl_item_categories
			mtl_item_revisions_b
			mtl_parameters
			hr_all_organizations_units
			cst_item_cost
			qp_list_headers
			jft_rs_salesreps