VIEW: APPS.HRBV_SUPERVISOR_HIERARCHY_V

Source

View Text - Preformatted

SELECT shy.Sup_Level Supervisor_Level, shy.Sub_Level Subordinate_Level, shy.Sub_Relative_Level Subordinate_Relative_Level, shy.Effective_Start_Date Effective_Start_Date, shy.Effective_End_Date Effective_End_Date, hr_bis.bis_decode_lookup('YES_NO',shy.Sub_Primary_Asg_Flag_Code) Sub_Primary_Asg_Flag, hr_bis.bis_decode_lookup('YES_NO',shy.Sup_Invalid_Flag_Code) Superv_Invalid_Flag, hr_bis.bis_decode_lookup('YES_NO',shy.Sub_Invalid_Flag_Code) Subord_Invalid_Flag, hr_bis.bis_decode_lookup('YES_NO',shy.Sub_Leaf_Flag_Code) Subord_Leaf_Flag, hr_bis.bis_decode_lookup('YES_NO',shy.Orphan_Flag_Code) Orphan_Flag, shy.Sub_Primary_Asg_Flag_Code Sub_Primary_Asg_Flag_Code, shy.Sup_Invalid_Flag_Code Superv_Invalid_Flag_Code, shy.Sub_Invalid_Flag_Code Subord_Invalid_Flag_Code, shy.Sub_Leaf_Flag_Code Subord_Leaf_Flag_Code, shy.Orphan_Flag_Code Orphan_Flag_Code, shy.Sup_Business_Group_Id Superv_Business_Group_Id, shy.Sup_Person_Id Supervisor_Id, shy.Sup_Assignment_Id Superv_Assignment_Id, shy.Sup_Assignment_Status_Type_Id Sup_Asg_Status_Type_Id, shy.Sub_Business_Group_Id Subord_Business_Group_Id, shy.Sub_Person_Id Subordinate_Id, shy.Sub_Assignment_Id Subord_Assignment_Id, shy.Sub_Assignment_Status_Type_Id Sub_Asg_Status_Type_Id, shy.Creation_Date Creation_Date, shy.Created_By Created_By, shy.Last_Update_Date Last_Update_Date, shy.Last_Updated_By Last_Updated_By, shy.Last_Update_Login Last_Update_Login FROM HRI_CS_SUPH shy, HR_ALL_ORGANIZATION_UNITS hou WHERE hou.organization_id = shy.sup_business_group_id

View Text - HTML Formatted

SELECT SHY.SUP_LEVEL SUPERVISOR_LEVEL
, SHY.SUB_LEVEL SUBORDINATE_LEVEL
, SHY.SUB_RELATIVE_LEVEL SUBORDINATE_RELATIVE_LEVEL
, SHY.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SHY.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SHY.SUB_PRIMARY_ASG_FLAG_CODE) SUB_PRIMARY_ASG_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SHY.SUP_INVALID_FLAG_CODE) SUPERV_INVALID_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SHY.SUB_INVALID_FLAG_CODE) SUBORD_INVALID_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SHY.SUB_LEAF_FLAG_CODE) SUBORD_LEAF_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, SHY.ORPHAN_FLAG_CODE) ORPHAN_FLAG
, SHY.SUB_PRIMARY_ASG_FLAG_CODE SUB_PRIMARY_ASG_FLAG_CODE
, SHY.SUP_INVALID_FLAG_CODE SUPERV_INVALID_FLAG_CODE
, SHY.SUB_INVALID_FLAG_CODE SUBORD_INVALID_FLAG_CODE
, SHY.SUB_LEAF_FLAG_CODE SUBORD_LEAF_FLAG_CODE
, SHY.ORPHAN_FLAG_CODE ORPHAN_FLAG_CODE
, SHY.SUP_BUSINESS_GROUP_ID SUPERV_BUSINESS_GROUP_ID
, SHY.SUP_PERSON_ID SUPERVISOR_ID
, SHY.SUP_ASSIGNMENT_ID SUPERV_ASSIGNMENT_ID
, SHY.SUP_ASSIGNMENT_STATUS_TYPE_ID SUP_ASG_STATUS_TYPE_ID
, SHY.SUB_BUSINESS_GROUP_ID SUBORD_BUSINESS_GROUP_ID
, SHY.SUB_PERSON_ID SUBORDINATE_ID
, SHY.SUB_ASSIGNMENT_ID SUBORD_ASSIGNMENT_ID
, SHY.SUB_ASSIGNMENT_STATUS_TYPE_ID SUB_ASG_STATUS_TYPE_ID
, SHY.CREATION_DATE CREATION_DATE
, SHY.CREATED_BY CREATED_BY
, SHY.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SHY.LAST_UPDATED_BY LAST_UPDATED_BY
, SHY.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM HRI_CS_SUPH SHY
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE HOU.ORGANIZATION_ID = SHY.SUP_BUSINESS_GROUP_ID