APPS.OPIMXRU dependencies on HR_ORGANIZATION_INFORMATION

Line 26: HR_ORGANIZATION_INFORMATION hoi

22: bom_department_resources bdr,
23: wip_transactions wt,
24: mtl_parameters mp,
25: mtl_uom_conversions m2,
26: HR_ORGANIZATION_INFORMATION hoi
27: WHERE
28: -- 1->resource trx 3-> outside processing,
29: -- both involve resource, other types don't have resource_id
30: wt.transaction_type IN (1,3)

Line 99: HR_ORGANIZATION_INFORMATION hoi

95: bom_department_resources bdr,
96: bom_calendar_dates bcd,
97: mtl_parameters mp,
98: mtl_units_of_measure m2,
99: HR_ORGANIZATION_INFORMATION hoi
100: WHERE bdr.available_24_hours_flag = 1 -- 24 hr available
101: AND bdr.share_from_dept_id IS NULL -- owing dept
102: AND br.resource_id = bdr.resource_id
103: AND m2.uom_code = br.unit_of_measure

Line 150: HR_ORGANIZATION_INFORMATION hoi

146: bom_shift_dates bsd,
147: bom_shift_times bst,
148: mtl_parameters mp,
149: mtl_units_of_measure m2,
150: HR_ORGANIZATION_INFORMATION hoi
151: WHERE bdr.available_24_hours_flag = 2 -- shift based
152: AND bdr.share_from_dept_id IS NULL -- owning dept
153: AND br.resource_id = bdr.resource_id
154: AND m2.uom_code = br.unit_of_measure