DBA Data[Home] [Help]

APPS.OPIMXRU dependencies on BOM_DEPARTMENT_RESOURCES

Line 22: bom_department_resources bdr,

18: SUM(primary_quantity* m2.conversion_rate/l_hr_base_rate) act_res_usage
19: FROM
20: bom_resources br,
21: bom_departments bd,
22: bom_department_resources bdr,
23: wip_transactions wt,
24: mtl_parameters mp,
25: mtl_uom_conversions m2,
26: HR_ORGANIZATION_INFORMATION hoi

Line 95: bom_department_resources bdr,

91: 0,
92: 24* bdr.capacity_units
93: FROM bom_resources br,
94: bom_departments bd,
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

Line 144: bom_department_resources bdr,

140: SUM((bst.to_time - bst.from_time)/3600*bdr.capacity_units) avail_res
141: FROM
142: bom_resources br,
143: bom_departments bd,
144: bom_department_resources bdr,
145: bom_resource_shifts brs,
146: bom_shift_dates bsd,
147: bom_shift_times bst,
148: mtl_parameters mp,