Organization Query In Oracle Apps R12

Trang chủ » Hr_organization_units In Oracle Apps » Organization Query In Oracle Apps R12

Có thể bạn quan tâm

Gaurav Oracle Technology Blog

This blog is only for fresher who want to learn through practicing and on yourself, specially in oracle related technology like forms reports pl/sql sql, Oracle Apps, and Retail and also for some kind of realistic people.

Thursday, August 1, 2013

Organization Query in Oracle Apps R12

select * from HR_LOCATIONS wheretrunc(sysdate)=trunc(creation_date)and location_id =30982 select * from HR_ORGANIZATION_UNITS wheretrunc(sysdate)=trunc(creation_date) select * from HR_ALL_ORGANIZATION_UNITS wheretrunc(sysdate)=trunc(creation_date) select ORGANIZATION_ID, NAME, BUSINESS_GROUP_ID, LOCATION_ID, DATE_FROM, INTERNAL_EXTERNAL_FLAG, INTERNAL_ADDRESS_LINE, TYPEfrom HR_ALL_ORGANIZATION_UNITS wheretrunc(sysdate)=trunc(creation_date) select * from HR_ORGANIZATION_INFORMATION wheretrunc(sysdate)=trunc(creation_date) select ORG_INFORMATION_ID, ORGANIZATION_ID, ORG_INFORMATION_CONTEXT, ORG_INFORMATION1 from HR_ORGANIZATION_INFORMATION wheretrunc(sysdate)=trunc(creation_date) All organizations are maintained in HR_ALL_ORGANIZATION_UNITS tableandorganization classifications like Legal entity or operating unit information are stored in HR_ORGANIZATION_INFORMATION table. There are 3views provided based on these 2tablesto easily find out the Legal entity, Operating unit and Inventory organization viz: select ORGANIZATION_ID, BUSINESS_GROUP_ID , NAME, DATE_FROM , DATE_TO fromapps.HR_LEGAL_ENTITIES select ORGANIZATION_ID, BUSINESS_GROUP_ID, NAME, DATE_FROM, DATE_TO, SET_OF_BOOKS_ID from HR_OPERATING_UNITS select ORGANIZATION_ID, BUSINESS_GROUP_ID, USER_DEFINITION_ENABLE_DATE, DISABLE_DATE, ORGANIZATION_CODE, ORGANIZATION_NAME, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, INVENTORY_ENABLED_FLAG, OPERATING_UNIT, LEGAL_ENTITY from ORG_ORGANIZATION_DEFINITIONS Queryto find few business groupsset up intheinstance: select business_group_id,name from per_business_groups wherelower(name)like'%vision corporation%' orderbyname Queryto find SOBs set up intheinstance: 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 queryto 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=204and ORGANIZATION_ID =9073 orderby 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 wheretrunc(sysdate)=trunc(creation_date) select * from MTL_SECONDARY_INVENTORIES wheretrunc(sysdate)=trunc(creation_date) select * from MTL_UOM_CLASSES wheretrunc(sysdate)=trunc(creation_date) select * from MTL_ITEM_LOCATIONS wheretrunc(sysdate)=trunc(creation_date) Posted by at 2:36 AM Labels: HR_ALL_ORGANIZATION_UNITS, HR_LEGAL_ENTITIES, HR_ORGANIZATION_UNITS, org_organization_definitions

No comments:

Post a Comment

Older Post Home Subscribe to: Post Comments (Atom)

Followers

Blog Archive

  • ▼  2013 (7)
    • ▼  August (1)
      • Organization Query in Oracle Apps R12

About Me

My photo Gaurav New Delhi, New Delhi, India Oracle Engineer View my complete profile  

Từ khóa » Hr_organization_units In Oracle Apps