Skip to main content

Query to find Operating Unit, Business Group and Legal Entity Information

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   apps.xle_entity_profiles lep,
       apps.xle_registrations reg,
       apps.hr_locations_all hrl,
       apps.hz_parties hzp,
       apps.fnd_territories_vl ter,
       apps.hr_operating_units hro,
       apps.hr_all_organization_units_tl hroutl_bg,
       apps.hr_all_organization_units_tl hroutl_ou,
       hr_organization_units gloperatingunitseo,
       apps.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
       AND hro.date_to IS NULL 

Comments

Post a Comment

Popular posts from this blog

SQL Query to extract Oracle Purchase Order Information

SELECT   poh.po_header_id,    poh.type_lookup_code PO_TYPE,   poh.authorization_status PO_STATUS,   poh.segment1 PO_NUMBER,   pov.vendor_name SUPPLIER_NAME,   povs.vendor_site_code Location,   hrls.location_code Ship_To,   hrlb.location_code Bill_to,   pol.line_num ,   msib.segment1 Item,   pol.unit_price,   pol.quantity,   pod.amount_billed Amount,   pod.destination_subinventory,   ppf.full_name Buyer_Name,   poh.closed_Code  FROM   PO_HEADERS_ALL poh,   PO_LINES_ALL pol,   mtl_system_items_b msib,   PO_LINE_LOCATIONS_ALL poll,   PO_DISTRIBUTIONS_ALL pod,   po_vendors pov,   po_vendor_sites_All povs,   hr_locations_all hrls,   hr_locations_all hrlb,   per_all_people_f ppf,   po_line_types polt WHERE   1                         =1 AND polt.line...
Post a Comment
Read more

How To Enable / Disable Forms Personalization Option

Forms Personalization gives great flexibility to execute custom business logic without performing so much of technical work. To start forms personalization navigate to Help -> Diagnostics -> Custom Code -> Personalize But many time when we click on personalize it give below error  " Function is not available for this respnosibility. Change responsibilities or contact your System Administrator " To Enable access to forms personalization function we need to set below profile option.  -  Utilities:Diagnostics -> Yes / No It determines the diagnostics option is enabled for a user / responsibility or site, depending on the level profile option is set. Navigate to System Administrator -> Profile -> System Query for your user / responsibility for which you want to provide access. Set the value to 'Yes' , If you want allow access to forms personalization Since we change the profile option please change the respons...
Post a Comment
Read more