SELECT mp.organization_code, hou.name, hou.organization_id, null, null, null, null, null, null, null, null, null, null, null from hr_organization_units hou, mtl_parameters mp, HR_ORGANIZATION_INFORMATION HOI1 WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_id AND HOI1.ORG_INFORMATION1= 'INV' AND HOI1.ORG_INFORMATION2 = 'Y'
SELECT MP.ORGANIZATION_CODE
, HOU.NAME
, HOU.ORGANIZATION_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ORGANIZATION_UNITS HOU
, MTL_PARAMETERS MP
, HR_ORGANIZATION_INFORMATION HOI1
WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1= 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
|
|
|