DBA Data[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on BOM_DEPARTMENTS

Line 251: FROM bom_departments

247: IF p_work_order_rec.owning_department is not null THEN
248: l_dept_id := p_work_order_rec.owning_department;
249: ELSE if p_work_order_rec.owning_department_code is not null THEN
250: SELECT department_id into l_dept_id
251: FROM bom_departments
252: WHERE department_code = p_work_order_rec.owning_department_code and organization_id= p_work_order_rec.organization_id;
253: ELSE
254: WIP_EAMWORKORDER_PVT.Get_EAM_Owning_Dept_Default
255: ( p_api_version => 1.0,