Query To Fetch Legal Entity, Business Group Details In Oracle Apps R12

Trang chủ » Hr_organization_units All » Query To Fetch Legal Entity, Business Group Details In Oracle Apps R12

Có thể bạn quan tâm

Oracle Apps Knowledge Sharing

Meant for sharing our knowledge related to Oracle E-Business Suite

  • HOME
  • TECHNICAL TUTORIALS
  • USEFUL LINKS
  • ARTICLE INDEX
  • VIDEO INDEX

Friday, August 1, 2014

Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v

Query to fetch Business group Details - 1 SELECT business_group_id, organization_id, NAME, date_from, date_to, internal_address_line, location_id, comments, default_start_time, default_end_time, working_hours, frequency, short_name, method_of_generation_emp_num, method_of_generation_apl_num, grade_structure, people_group_structure, job_structure, cost_allocation_structure, position_structure, legislation_code, currency_code, security_group_id, enabled_flag, competence_structure, method_of_generation_cwk_num FROM per_business_groups; Query to fetch Business group Details - 2 SELECT o.organization_id, o.organization_id, otl.NAME, o.date_from, o.date_to, o.internal_address_line, o.location_id, o.comments FROM hr_all_organization_units o, hr_all_organization_units_tl otl, hr_organization_information o2, hr_organization_information o3, hr_organization_information o4 WHERE o.organization_id = otl.organization_id AND o.organization_id = o2.organization_id(+) AND o.organization_id = o3.organization_id AND o.organization_id = o4.organization_id AND o3.org_information_context = 'Business Group Information' AND o2.org_information_context(+) = 'Work Day Information' AND o4.org_information_context = 'CLASS' AND o4.org_information1 = 'HR_BG' AND o4.org_information2 = 'Y'; Query to fetch Legal Entity Details SELECT xle_firstpty.NAME, xle_firstpty.activity_code, xle_firstpty.sub_activity_code, xle_firstpty.registration_number, xle_firstpty.effective_from, xle_firstpty.location_id, xle_firstpty.address_line_1, xle_firstpty.address_line_2, xle_firstpty.address_line_3, xle_firstpty.town_or_city, xle_firstpty.region_1, xle_firstpty.region_2, xle_firstpty.region_3, xle_firstpty.postal_code, xle_firstpty.country, xle_firstpty.address_style, xle_cont.contact_name, xle_cont.contact_legal_id, xle_cont.title, xle_cont.job_title, xle_cont.role FROM xle_firstparty_information_v xle_firstpty, xle_legal_contacts_v xle_cont WHERE 1 = 1 AND XLE_FIRSTPTY.LEGAL_ENTITY_ID = C_REP_ENTITY_ID AND xle_firstpty.legal_entity_id = xle_cont.entity_id(+); Query to fetch legal entity details along with OU details SELECT DISTINCT hrl.country, hroutl_bg.NAME bg, hroutl_bg.organization_id, lep.legal_entity_id, lep.NAME legal_entity, hroutl_ou.NAME ou_name, hroutl_ou.organization_id org_id, hrl.location_id, hrl.location_code, glev.flex_segment_value FROM xle_entity_profiles lep, xle_registrations reg, hr_locations_all hrl, hz_parties hzp, fnd_territories_vl ter, hr_operating_units hro, hr_all_organization_units_tl hroutl_bg, hr_all_organization_units_tl hroutl_ou, hr_organization_units gloperatingunitseo, gl_legal_entities_bsvs glev WHERE lep.transacting_entity_flag = 'Y' AND lep.party_id = hzp.party_id AND lep.legal_entity_id = reg.source_id AND reg.source_table = 'XLE_ENTITY_PROFILES' AND hrl.location_id = reg.location_id AND reg.identifying_flag = 'Y' AND ter.territory_code = hrl.country AND lep.legal_entity_id = hro.default_legal_context_id AND gloperatingunitseo.organization_id = hro.organization_id AND hroutl_bg.organization_id = hro.business_group_id AND hroutl_ou.organization_id = hro.organization_id AND glev.legal_entity_id = lep.legal_entity_id;

Do you think this Article is useful?

Related Posts Widget for Blogger

0 Responses to “Query to fetch Legal Entity, Business group details in Oracle Apps R12 - per_business_groups,xle_firstparty_information_v”

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.

Stay Connected

Follow @shareoracleapps

Followers

Modules

Accounting (6) AP (58) API's (190) AR (56) Cash Management (23) DBA (23) DBMS_DDL (1) DBMS_LOB (1) DBMS_SCHEDULER (8) DBMS_UTILITY (4) DBMS_XSLPROCESSOR (2) DIRECT PUNCHOUT (1) E-Commerce Gateway (1) EDI (1) ETEXT Templates (5) Fixed Assets (4) FND (79) Forms Personalization (4) Human Resources (HR) (11) Interview Questions (17) Inventory (27) iSourcing (1) iSuppliers (3) JAVA (1) Jdeveloper Issues (1) Oracle (75) Oracle Alerts (3) Oracle Application Framework(OAF) (2) Oracle apps (408) Oracle E-Business Tax (2) Oracle General Ledger (23) Oracle iProcurement (8) Oracle Payments (18) Oracle Process Manufacturing (1) Oracle Purchasing (26) Order Management (44) PDOI Sample Scripts (2) PLSQL (44) PLSQL Tuning Examples (4) REUSABLE CODE (24) Scripts (82) SED (1) Shell Scripts (6) SOA (12) SQL (35) SQL TUTORIAL (17) Sub Ledger Accounting (7) Supplier API's (9) TCA (41) Useful Queries (82) UTL_ENCODE (1) UTL_FILE (2) UTL_MATCH (1) UTL_URL (1) Workflow (9) Workflow Mailer (1) XML Publisher (10)

Popular Posts

  • Procure To Pay Cycle in Oracle Apps R12 (P2P Cycle)
  • WSH_DELIVERY_DETAILS.RELEASED_STATUS ( Pick Release Status)
  • Query to fetch Purchase Receipt and its related Purchase order, Vendor details in Oracle Apps R12 (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES)
  • API to add responsibility to a user (FND_USER_PKG.ADDRESP)
  • Query to Fetch Employee Details in Oracle Apps R12 (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_ALL_POSITIONS, PER_PHONES)
  • Query to get basic AP Invoice and Payment information from Oracle Apps R12
  • Key Flex Field Structures & How to Retrieve Information about segments based on code combination id
  • Forms Personalization in Oracle Apps R12 Example: Zoom Functionality
  • API to find AP INVOICE Status (AP_INVOICES_PKG.GET_APPROVAL_STATUS)
  • Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)

Blog Archive

Blog Archive December 2022 (1) November 2022 (2) October 2022 (3) September 2022 (3) September 2021 (1) June 2021 (1) May 2021 (4) April 2021 (2) March 2021 (5) February 2021 (1) January 2021 (3) December 2020 (1) November 2020 (3) October 2020 (3) September 2020 (5) August 2020 (10) July 2020 (6) June 2020 (6) May 2020 (7) September 2019 (2) August 2019 (4) April 2019 (9) March 2019 (1) August 2018 (2) March 2018 (7) February 2018 (2) July 2017 (2) June 2017 (1) January 2017 (3) November 2016 (2) April 2016 (4) June 2015 (6) May 2015 (20) August 2014 (8) January 2014 (2) December 2013 (2) September 2013 (4) June 2013 (2) May 2013 (2) April 2013 (3) September 2012 (9) April 2012 (5) March 2012 (5) February 2012 (9) January 2012 (2) December 2011 (3) November 2011 (2) October 2011 (19) July 2011 (1) June 2011 (7) May 2011 (34) March 2011 (23) February 2011 (20) January 2011 (14) December 2010 (21) November 2010 (7) October 2010 (8) September 2010 (1) August 2010 (3) July 2010 (2) June 2010 (40) May 2010 (32) April 2010 (11) March 2010 (27) February 2010 (38) January 2010 (21) December 2009 (2)
shareoracleapps.com

Site Stats (Last 30 Days)

All Rights Reserved Oracle Apps Knowledge Sharing | Home by Team Search

Từ khóa » Hr_organization_units All