Query to find Organization information ,Tables and links ,ORGANIZATION_ID BASED ON SHIP TO BRANCH PLANT

OU & ORG ID & ORG CODE & ORG NAME
==================================

select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE,ORGANIZATION_NAME
from APPS.ORG_ORGANIZATION_DEFINITIONS;



ORGANIZATION_ID & SHORT CODE OF OU
===================================

select * from APPS.HR_OPERATING_UNITS;




ORGANIZATION_ID & ORGANIZATION_CODE
====================================

Select * from APPS.MTL_PARAMETERS;



ORGANIZATION_ID BASED ON SHIP TO BRANCH PLANT
==============================================

  SELECT organization_id
  FROM apps. mtl_parameters
  Where Attribute10 = '&ship_to_branch_plant'
 
ORGANIZATION_CODE BASED ON SHIP TO BRANCH PLANT
==============================================

select organization_code from apps. org_organization_definitions
where organization_id in (select organization_id from apps. mtl_parameters where
attribute10 = '&ship_to_branch_plant')

OU NAME& SHIP to branch plant:
================================
select HOU.NAME , MP.ORGANIZATION_CODE , MP.ATTRIBUTE10 from APPS.HR_OPERATING_UNITS HOU , APPS.MTL_PARAMETERS MP,APPS.ORG_ORGANIZATION_DEFINITIONS OOD
where HOU.ORGANIZATION_ID = OOD.OPERATING_UNIT
AND MP.ORGANIZATION_ID = OOD.ORGANIZATION_ID


OU_ID & OU_NAME & INV ORG ID & INV ORG CODE
==============================================

SELECT OOD.OPERATING_UNIT OU_ID ,
  HRO.NAME OU_NAME,
  OOD.ORGANIZATION_ID,
  OOD.ORGANIZATION_CODE,
  OOD.ORGANIZATION_NAME
FROM APPS.ORG_ORGANIZATION_DEFINITIONS OOD ,
  HR.HR_ALL_ORGANIZATION_UNITS HRO
WHERE OOD.OPERATING_UNIT = HRO.ORGANIZATION_ID
ORDER BY HRO.NAME,OOD.ORGANIZATION_CODE


==========================================================================

Post a Comment