APPS.WIP_JSI_VALIDATOR dependencies on WIP_DISCRETE_JOBS

Line 142: from wip_discrete_jobs WDJ

138:
139: if (wjsi_row.load_type = wip_constants.resched_job) then
140: select WDJ.build_sequence
141: into wjsi_row.build_sequence
142: from wip_discrete_jobs WDJ
143: where WDJ.wip_entity_id = wjsi_row.wip_entity_id ;
144: else
145: wjsi_row.build_sequence := null;
146: end if;

Line 366: update wip_discrete_jobs wdj

362:
363: if(l_serialOp is null) then
364: --in this case, we may need to clear the serialization op if the routing was re-exploded
365: if(l_loadType = wip_constants.resched_job) then
366: update wip_discrete_jobs wdj
367: set serialization_start_op = null
368: where wip_entity_id = l_wipID
369: and serialization_start_op <> 1
370: and not exists(select 1

Line 388: from wip_discrete_jobs wdj, mtl_system_items msi

384:
385: --job must have an assembly, and the assembly must be serial controlled (predefined).
386: select 1
387: into g_dummy
388: from wip_discrete_jobs wdj, mtl_system_items msi
389: where wdj.primary_item_id = msi.inventory_item_id
390: and wdj.organization_id = msi.organization_id
391: and wdj.wip_entity_id = l_wipID
392: and msi.serial_number_control_code = wip_constants.full_sn;

Line 424: from wip_discrete_jobs

420: --have taken place.
421: if(l_loadType = wip_constants.resched_job) then
422: select 1
423: into g_dummy
424: from wip_discrete_jobs
425: where wip_entity_id = l_wipID
426: and status_type = wip_constants.unreleased;
427: end if;
428: exception

Line 502: from wip_discrete_jobs wdj, wip_entities we

498: wdj_row.task_id,
499: wdj_row.completion_subinventory,
500: wdj_row.completion_locator_id,
501: wdj_row.rebuild_item_id
502: from wip_discrete_jobs wdj, wip_entities we
503: where wdj.wip_entity_id = wjsi_row.wip_entity_id
504: and we.wip_entity_id = wjsi_row.wip_entity_id;
505: if(wdj_row.primary_item_id is not null) then
506: populate_item(p_item_id => wdj_row.primary_item_id,

Line 918: from wip_discrete_jobs

914: in wip_job_schedule_interface is null */
915: if ( wjsi_row.primary_item_id is null ) then
916: select primary_item_id /* for Bug2792736 */
917: into l_Primary_Item_Id
918: from wip_discrete_jobs
919: where wip_entity_id = wjsi_row.wip_entity_id
920: and organization_id = wjsi_row.organization_id;
921: end if;
922:

Line 2007: from wip_discrete_jobs

2003: elsif (wdj_row.status_type = WIP_CONSTANTS.UNRELEASED) then
2004: if (wjsi_row.end_item_unit_number is null) then
2005: begin
2006: select end_item_unit_number into wjsi_row.end_item_unit_number
2007: from wip_discrete_jobs
2008: where wip_entity_id =
2009: (select wip_entity_id
2010: from wip_job_schedule_interface
2011: where rowid = WIP_JSI_UTILS.CURRENT_ROWID

Line 2023: from wip_discrete_jobs

2019: else
2020: begin
2021: -- bug#2719927, bom revision code/reexplosion is based on bom_reference_id
2022: select primary_item_id into wjsi_row.bom_reference_id
2023: from wip_discrete_jobs
2024: where wip_entity_id = wjsi_row.wip_entity_id;
2025: exception
2026: when others then
2027: FND_Message.set_name('WIP', 'WIP_ML_PRIMARY_ITEM_ID') ;

Line 2041: from wip_discrete_jobs

2037: end if;
2038:
2039: begin
2040: select end_item_unit_number into wjsi_row.end_item_unit_number
2041: from wip_discrete_jobs
2042: where wip_entity_id =
2043: (select wip_entity_id
2044: from wip_job_schedule_interface
2045: where rowid = WIP_JSI_UTILS.CURRENT_ROWID