Tuesday, March 22, 2016

Query to find few business groups set up in the instance,A very important query to find out inventory organizations for an operating unit :


Query to find few business groups set up in the instance



select
   business_group_id,name
from per_business_groups
where lower(name) like '%vision corporation%'
order by name

Query to find SOBs set up in the instance :

select
   set_of_books_id,
   name sob_name,
   chart_of_accounts_id,
   chart_of_accounts_name,
   period_set_name calendar_period,
   accounted_period_type,
   user_period_type,
   currency_code
from gl_sets_of_books_v
where set_of_books_id=1

A very important query to find out  inventory organizations for an operating unit :

select
   organization_id,
   organization_code,
   organization_name,
   (select location_id from hr_all_organization_units ou
     where od.organization_id=ou.organization_id) location_id,
   user_definition_enable_date,
   disable_date,
   chart_of_accounts_id,
   inventory_enabled_flag,
   operating_unit,
   legal_entity,
   set_of_books_id,
   business_group_id
from org_organization_definitions od
where operating_unit=204 and ORGANIZATION_ID = 9073
order by organization_code


select * from org_organization_definitions where ORGANIZATION_NAME like 'M12%'--trunc(sysdate) = trunc(creation_date)

select *from mtl_parameters where ORGANIZATION_ID = 9073

select * from MTL_SECONDARY_INVENTORIES_FK_V where trunc(sysdate) = trunc(creation_date)

select * from MTL_SECONDARY_INVENTORIES where trunc(sysdate) = trunc(creation_date)

select * from MTL_UOM_CLASSES where trunc(sysdate) = trunc(creation_date)

select * from MTL_ITEM_LOCATIONS  where trunc(sysdate) = trunc(creation_date)

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...