DBA Data[Home] [Help]

APPS.OPIMXRU dependencies on BOM_RESOURCES

Line 20: bom_resources br,

16: bd.department_code,
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,

Line 93: FROM bom_resources br,

89: bd.department_code, bcd.calendar_date, To_number(hoi.org_information1),
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,

Line 142: bom_resources br,

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