DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on BOM_DEPARTMENTS

Line 2493: from bom_departments

2489: wjsi_row.owning_department is not null) then
2490: l_job_date := nvl(wjsi_row.last_unit_completion_date, nvl(wjsi_row.first_unit_start_date, wdj_row.scheduled_completion_date));
2491: select disable_date
2492: into l_disable_date
2493: from bom_departments
2494: where department_id = wjsi_row.owning_department
2495: and organization_id = wjsi_row.organization_id;
2496:
2497: if(l_disable_date is not null and