eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PQH_POSN_CTL_HIERARCHY_V

Source

View Text - Preformatted


SELECT 0 ROW_NUM, 0 HIERARCHY_LEVEL, hr_general.decode_organization(business_group_id) BUSINESS_GROUP_NAME, business_group_id BUSINESS_GROUP_ID, hr_general.decode_organization(organization_id) ORGANIZATION_NAME, organization_id ORGANIZATION_ID, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(organization_id) PC_ENABLED_FLAG FROM hr_all_organization_units WHERE organization_id = pqh_psf_bus.get_pc_topnode AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(organization_id),'N') = 'Y' UNION SELECT rownum ROW_NUM, level HIERARCHY_LEVEL, hr_general.decode_organization(a.business_group_id) BUSINESS_GROUP_NAME, a.business_group_id BUSINESS_GROUP_ID, hr_general.decode_organization(a.organization_id_child ) ORGANIZATION_NAME, a.organization_id_child ORGANIZATION_ID, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(a.organization_id_child) PC_ENABLED_FLAG FROM per_org_structure_elements a WHERE a.business_group_id = NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID')) AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(a.organization_id_child),'N') = 'Y' START WITH organization_id_parent = pqh_psf_bus.get_pc_topnode AND org_structure_version_id = pqh_psf_bus.get_pc_str_version CONNECT BY a.organization_id_parent = PRIOR a.organization_id_child AND a.org_structure_version_id = PRIOR a.org_structure_version_id

View Text - HTML Formatted

SELECT 0 ROW_NUM
, 0 HIERARCHY_LEVEL
, HR_GENERAL.DECODE_ORGANIZATION(BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_ORGANIZATION(ORGANIZATION_ID) ORGANIZATION_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(ORGANIZATION_ID) PC_ENABLED_FLAG
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = PQH_PSF_BUS.GET_PC_TOPNODE
AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(ORGANIZATION_ID)
, 'N') = 'Y' UNION SELECT ROWNUM ROW_NUM
, LEVEL HIERARCHY_LEVEL
, HR_GENERAL.DECODE_ORGANIZATION(A.BUSINESS_GROUP_ID) BUSINESS_GROUP_NAME
, A.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_ORGANIZATION(A.ORGANIZATION_ID_CHILD ) ORGANIZATION_NAME
, A.ORGANIZATION_ID_CHILD ORGANIZATION_ID
, PQH_PSF_BUS.POSITION_CONTROL_ENABLED(A.ORGANIZATION_ID_CHILD) PC_ENABLED_FLAG
FROM PER_ORG_STRUCTURE_ELEMENTS A
WHERE A.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
AND NVL(PQH_PSF_BUS.POSITION_CONTROL_ENABLED(A.ORGANIZATION_ID_CHILD)
, 'N') = 'Y' START WITH ORGANIZATION_ID_PARENT = PQH_PSF_BUS.GET_PC_TOPNODE
AND ORG_STRUCTURE_VERSION_ID = PQH_PSF_BUS.GET_PC_STR_VERSION CONNECT BY A.ORGANIZATION_ID_PARENT = PRIOR A.ORGANIZATION_ID_CHILD
AND A.ORG_STRUCTURE_VERSION_ID = PRIOR A.ORG_STRUCTURE_VERSION_ID