VIEW: APPS.IGW_PRP_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT hr.organization_id, hr.name, hr.business_group_id from hr_organization_units hr WHERE hr.organization_id in ( select se.organization_id_child from per_org_structure_elements se where se.org_structure_version_id = ( select prp_org_structure_version_id from igw_implementations ) connect by prior se.organization_id_child = se.organization_id_parent and prior se.org_structure_version_id = se.org_structure_version_id start with se.organization_id_parent = ( select prp_org_structure_start_id from igw_implementations ) union select prp_org_structure_start_id from igw_implementations ) and trunc(sysdate) between date_from and nvl(date_to, trunc(sysdate)) and igw_security.gms_enabled = 'N' union select code, description, business_group_id from pa_organizations_lov_v where igw_security.gms_enabled = 'Y'

View Text - HTML Formatted

SELECT HR.ORGANIZATION_ID
, HR.NAME
, HR.BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS HR
WHERE HR.ORGANIZATION_ID IN ( SELECT SE.ORGANIZATION_ID_CHILD
FROM PER_ORG_STRUCTURE_ELEMENTS SE
WHERE SE.ORG_STRUCTURE_VERSION_ID = ( SELECT PRP_ORG_STRUCTURE_VERSION_ID
FROM IGW_IMPLEMENTATIONS ) CONNECT BY PRIOR SE.ORGANIZATION_ID_CHILD = SE.ORGANIZATION_ID_PARENT
AND PRIOR SE.ORG_STRUCTURE_VERSION_ID = SE.ORG_STRUCTURE_VERSION_ID START WITH SE.ORGANIZATION_ID_PARENT = ( SELECT PRP_ORG_STRUCTURE_START_ID
FROM IGW_IMPLEMENTATIONS ) UNION SELECT PRP_ORG_STRUCTURE_START_ID
FROM IGW_IMPLEMENTATIONS )
AND TRUNC(SYSDATE) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE))
AND IGW_SECURITY.GMS_ENABLED = 'N' UNION SELECT CODE
, DESCRIPTION
, BUSINESS_GROUP_ID
FROM PA_ORGANIZATIONS_LOV_V
WHERE IGW_SECURITY.GMS_ENABLED = 'Y'