DBA Data[Home] [Help]

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