APPS.WIP_JSI_VALIDATOR dependencies on WIP_DISCRETE_JOBS

Line 147: from wip_discrete_jobs WDJ

143:
144: if (wjsi_row.load_type = wip_constants.resched_job) then
145: select WDJ.build_sequence
146: into wjsi_row.build_sequence
147: from wip_discrete_jobs WDJ
148: where WDJ.wip_entity_id = wjsi_row.wip_entity_id ;
149: else
150: wjsi_row.build_sequence := null;
151: end if;

Line 371: update wip_discrete_jobs wdj

367:
368: if(l_serialOp is null) then
369: --in this case, we may need to clear the serialization op if the routing was re-exploded
370: if(l_loadType = wip_constants.resched_job) then
371: update wip_discrete_jobs wdj
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

Line 393: from wip_discrete_jobs wdj, mtl_system_items msi

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

Line 429: from wip_discrete_jobs

425: --have taken place.
426: if(l_loadType = wip_constants.resched_job) then
427: select 1
428: into g_dummy
429: from wip_discrete_jobs
430: where wip_entity_id = l_wipID
431: and status_type = wip_constants.unreleased;
432: end if;
433: exception

Line 507: from wip_discrete_jobs wdj, wip_entities we

503: wdj_row.task_id,
504: wdj_row.completion_subinventory,
505: wdj_row.completion_locator_id,
506: wdj_row.rebuild_item_id
507: from wip_discrete_jobs wdj, wip_entities we
508: where wdj.wip_entity_id = wjsi_row.wip_entity_id
509: and we.wip_entity_id = wjsi_row.wip_entity_id;
510: if(wdj_row.primary_item_id is not null) then
511: populate_item(p_item_id => wdj_row.primary_item_id,

Line 923: from wip_discrete_jobs

919: in wip_job_schedule_interface is null */
920: if ( wjsi_row.primary_item_id is null ) then
921: select primary_item_id /* for Bug2792736 */
922: into l_Primary_Item_Id
923: from wip_discrete_jobs
924: where wip_entity_id = wjsi_row.wip_entity_id
925: and organization_id = wjsi_row.organization_id;
926: end if;
927:

Line 2012: from wip_discrete_jobs

2008: elsif (wdj_row.status_type = WIP_CONSTANTS.UNRELEASED) then
2009: if (wjsi_row.end_item_unit_number is null) then
2010: begin
2011: select end_item_unit_number into wjsi_row.end_item_unit_number
2012: from wip_discrete_jobs
2013: where wip_entity_id =
2014: (select wip_entity_id
2015: from wip_job_schedule_interface
2016: where rowid = WIP_JSI_UTILS.CURRENT_ROWID

Line 2028: from wip_discrete_jobs

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

Line 2046: from wip_discrete_jobs

2042: end if;
2043:
2044: begin
2045: select end_item_unit_number into wjsi_row.end_item_unit_number
2046: from wip_discrete_jobs
2047: where wip_entity_id =
2048: (select wip_entity_id
2049: from wip_job_schedule_interface
2050: where rowid = WIP_JSI_UTILS.CURRENT_ROWID