[Home] [Help]
412: procedure line_code is begin
413: if(wjsi_row.line_id is null and wjsi_row.line_code is not null) then
414: select line_id
415: into wjsi_row.line_id
416: from wip_lines_val_v
417: where line_code = wjsi_row.line_code
418: and organization_id = wjsi_row.organization_id;
419: elsif(wjsi_row.line_id is not null and wjsi_row.line_code is not null) then
420: WIP_JSI_Utils.record_ignored_column_warning('LINE_CODE');
997: where b2.calendar_date = trunc(wjsi_row.last_unit_start_date)
998: and b2.calendar_code = mp.calendar_code
999: and b2.exception_set_id = bcd.exception_set_id)
1000: and (exists (select 1
1001: from wip_lines wl
1002: where wl.line_id = wjsi_row.line_id
1003: and wl.line_schedule_type = 2))
1004: and (not exists (select 1
1005: from bom_operational_routings bor,
1064: where b2.calendar_date = trunc(wjsi_row.first_unit_start_date)
1065: and b2.calendar_code = mp.calendar_code
1066: and b2.exception_set_id = bcd.exception_set_id)
1067: and (exists (select 1
1068: from wip_lines wl
1069: where wl.line_id = wjsi_row.line_id
1070: and wl.line_schedule_type = 2))
1071: and (not exists (select 1
1072: from bom_operational_routings bor,
1103: where b2.calendar_date = trunc(wjsi_row.last_unit_completion_date)
1104: and b2.calendar_code = mp.calendar_code
1105: and b2.exception_set_id = bcd.exception_set_id)
1106: and (exists (select 1
1107: from wip_lines wl
1108: where wl.line_id = wjsi_row.line_id
1109: and wl.line_schedule_type = 2))
1110: and (not exists (select 1
1111: from bom_operational_routings bor,
1141: where b2.calendar_date = trunc(wjsi_row.first_unit_completion_date)
1142: and b2.calendar_code = mp.calendar_code
1143: and b2.exception_set_id = bcd.exception_set_id)
1144: and (exists (select 1
1145: from wip_lines wl
1146: where wl.line_id = wjsi_row.line_id
1147: and wl.line_schedule_type = 2))
1148: and (not exists (select 1
1149: from bom_operational_routings bor,