61: IS
62: SELECT SUBSTR (hoi4.org_information1, 4, 2)
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id
62: SELECT SUBSTR (hoi4.org_information1, 4, 2)
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id
70: ,business_group_id AS bus_id
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id
70: ,business_group_id AS bus_id
71: FROM per_all_assignments_f asg
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id
70: ,business_group_id AS bus_id
71: FROM per_all_assignments_f asg
72: ,hr_soft_coding_keyflex scl
95: IS
96:
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id
96:
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id
104: ,business_group_id AS bus_id
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id
104: ,business_group_id AS bus_id
105: FROM per_all_assignments_f asg
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id
104: ,business_group_id AS bus_id
105: FROM per_all_assignments_f asg
106: ,hr_soft_coding_keyflex scl