DBA Data[Home] [Help]

APPS.OPIMXRU dependencies on BOM_DEPARTMENTS

Line 21: bom_departments bd,

17: To_number(hoi.org_information1) sob_id,
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,

Line 94: bom_departments bd,

90: p_uom_code,
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,

Line 143: bom_departments bd,

139: 0,
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,