SELECT imp.business_group_id ,imp.org_id ,imp.exp_org_structure_id ,orgstructure.name ,imp.exp_org_structure_version_id ,imp.exp_start_org_id ,org.name FROM pa_implementations imp ,per_organization_structures orgstructure ,hr_organization_units org WHERE imp.exp_org_structure_id = orgstructure.organization_structure_id AND imp.exp_start_org_id = org.organization_id
SELECT IMP.BUSINESS_GROUP_ID
, IMP.ORG_ID
, IMP.EXP_ORG_STRUCTURE_ID
, ORGSTRUCTURE.NAME
, IMP.EXP_ORG_STRUCTURE_VERSION_ID
, IMP.EXP_START_ORG_ID
, ORG.NAME
FROM PA_IMPLEMENTATIONS IMP
, PER_ORGANIZATION_STRUCTURES ORGSTRUCTURE
, HR_ORGANIZATION_UNITS ORG
WHERE IMP.EXP_ORG_STRUCTURE_ID = ORGSTRUCTURE.ORGANIZATION_STRUCTURE_ID
AND IMP.EXP_START_ORG_ID = ORG.ORGANIZATION_ID
|
|
|