APPS.WIP_JSI_PROCESSOR dependencies on WIP_DISCRETE_JOBS

Line 61: FROM wip_discrete_jobs wdj,

57: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB)) then
58: begin
59: select wdj.start_quantity
60: into x_old_start_quantity
61: FROM wip_discrete_jobs wdj,
62: wip_job_schedule_interface wi
63: WHERE
64: wi.rowid = WIP_JSI_Utils.current_rowid and
65: wi.wip_entity_id = wdj.wip_entity_id;

Line 107: INSERT INTO WIP_DISCRETE_JOBS

103: WIP_CONSTANTS.CREATE_NS_JOB,
104: WIP_CONSTANTS.CREATE_EAM_JOB))
105: then
106:
107: INSERT INTO WIP_DISCRETE_JOBS
108: (wip_entity_id,
109: organization_id,
110: last_update_date,
111: last_updated_by,

Line 408: FROM wip_discrete_jobs wdj,

404: select wdj.organization_id, wdj.wip_entity_id, wdj.primary_item_id,
405: wdj.common_bom_sequence_id, wdj.common_routing_sequence_id
406: into
407: x_org_id, x_entity_id, x_item_id, x_cmn_bom_seq_id, x_cmn_routing_seq_id
408: FROM wip_discrete_jobs wdj,
409: wip_job_schedule_interface wi
410: WHERE
411: wi.rowid = WIP_JSI_Utils.current_rowid and
412: wi.wip_entity_id = wdj.wip_entity_id;

Line 429: UPDATE WIP_DISCRETE_JOBS WDJ

425:
426:
427: elsif (x_load_type IN (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_EAM_JOB)) then
428:
429: UPDATE WIP_DISCRETE_JOBS WDJ
430: SET ( LAST_UPDATED_BY,
431: last_update_login,
432: request_id,
433: program_application_id,