APPS.WIP_JSI_VALIDATOR dependencies on BOM_DEPARTMENTS
Line 2498: from bom_departments
2494: wjsi_row.owning_department is not null) then
2495: l_job_date := nvl(wjsi_row.last_unit_completion_date, nvl(wjsi_row.first_unit_start_date, wdj_row.scheduled_completion_date));
2496: select disable_date
2497: into l_disable_date 2498: from bom_departments 2499: where department_id = wjsi_row.owning_department
2500: and organization_id = wjsi_row.organization_id;
2501:
2502: if(l_disable_date is not null and