APPS.WIP_JSI_VALIDATOR dependencies on WIP_OPERATIONS

Line 355: from wip_operations

351: l_loadType NUMBER;
352: l_jobType NUMBER;
353: cursor c_ops(v_wip_id number) is
354: select operation_seq_num
355: from wip_operations
356: where wip_entity_id = v_wip_id;
357:
358: l_curOpSeq NUMBER;
359: l_rtgExists boolean := false;

Line 376: from wip_operations wo

372: set serialization_start_op = null
373: where wip_entity_id = l_wipID
374: and serialization_start_op <> 1
375: and not exists(select 1
376: from wip_operations wo
377: where wo.wip_entity_id = wdj.wip_entity_id
378: and wo.operation_seq_num = wdj.serialization_start_op);
379: end if;
380: return;

Line 2226: from wip_operations

2222: l_qty := wjsi_row.start_quantity;
2223: elsif(wjsi_row.load_type in (wip_constants.resched_job, wip_constants.resched_eam_job)) then
2224: select count(*)
2225: into l_rtg_count
2226: from wip_operations
2227: where wip_entity_id = wjsi_row.wip_entity_id;
2228: l_qty := nvl(wjsi_row.start_quantity, wdj_row.start_quantity);
2229: end if;
2230: --if no routing exists, update the scheduling method appropriately