Query To Find Responsibility For Operating Unit Or Org_id

• by Yogesh Pachpute
• Posted on October 16, 2017October 16, 2017
• Useful SQL Scripts

1 2 3 4 5 6 7 8 9 10 11 12 13

SELECT frv.responsibility_name, fpov.profile_option_value org_id, hou.NAME FROM apps.fnd_profile_options_vl fpo, apps.fnd_responsibility_vl frv, apps.fnd_profile_option_values fpov, apps.hr_organization_units hou WHERE hou.NAME = <OU Name> AND fpov.profile_option_value = TO_CHAR (hou.organization_id) AND fpo.profile_option_id = fpov.profile_option_id AND fpo.user_profile_option_name = 'MO: Operating Unit' AND frv.responsibility_id = fpov.level_value ORDER BY frv.responsibility_name

Share this:

• X
• Facebook

Like Loading...

Related

Post navigation Query to find Org ID attached to responsibilityHow does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

Leave a comment Cancel reply

Δ

Categories

• AGIS – Advanced Global Intercompany (1)
• AR Reconciliation (8)
• BI Publisher (3)
• Cash Management (4)
• Cloud Enterprise Structure (2)
• Concurrent Processing in R12 (4)
• Conversion (3)
• Cost Management (3)
• ERP Accounting (7)
• ERP Integrations (1)
• Fixed Asset (22)
• General Ledger (34)
• GRC (8)
• iExpense (21)
• Intercompany Integrations (1)
• Linux Server Security and Maintenance (1)
• Microsoft Windows Configurations (5)
• Oracle Cloud Cutover Tasks (1)
• Oracle Cloud Fusion Financial (14)
• Oracle Cloud Requirement – Design (5)
• Oracle Cloud Security (2)
• Oracle Database (2)
• Oracle Fusion HCM (10)
• Oracle Fusion HCM Technical (5)
• Oracle Fusion Technical (11)
• Oracle Installations (2)
• Oracle Inventory (2)
• Oracle SQL (4)
• Order Management (4)
• Payables (48)
• Payables Period Close (10)
• Payables Reconciliation (10)
• Payments (29)
• Payroll (1)
• Perl and Unix Scripting (1)
• Purchasing (4)
• Receivables (17)
• Receivables Period Close (15)
• Receiving Subledger (3)
• RMCS (46)
• SubLedger Accounting (26)
• Subscription Management (2)
• Supplier Modeling (1)
• Supply Chain Managment (1)
• TCA – DQM (1)
• Uncategorized (4)
• Useful SQL Scripts (4)
• Workday (7)

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address:

Subscribe

Join 41 other subscribers

• Comment
• Reblog
• Subscribe Subscribed
  • Enterprise Resource Planning and Integrations BlogSpot
  Join 41 other subscribers Sign me up
  • Already have a WordPress.com account? Log in now.
• • Enterprise Resource Planning and Integrations BlogSpot
  • Subscribe Subscribed
  • Sign up
  • Log in
  • Copy shortlink
  • Report this content
  • View post in Reader
  • Manage subscriptions
  • Collapse this bar

%d