APPS.WIP_JSI_PROCESSOR dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 54: from wip_job_schedule_interface

50: l_pm_sched_id,
51: l_project_id,
52: l_task_id,
53: l_move_order_required
54: from wip_job_schedule_interface
55: where rowid = WIP_JSI_Utils.current_rowid ;
56:
57: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB)) then
58: begin

Line 62: wip_job_schedule_interface wi

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;
66: exception

Line 339: wip_job_schedule_interface wi

335: FROM wip_accounting_classes wac,
336: bom_operational_routings rtg,
337: bom_bill_of_materials bom,
338: wip_parameters params,
339: wip_job_schedule_interface wi
340: WHERE
341: wi.rowid = WIP_JSI_Utils.current_rowid
342: AND nvl(rtg.cfm_routing_flag,2) = 2
343: AND wac.class_code(+)=wi.class_code

Line 391: FROM WIP_JOB_SCHEDULE_INTERFACE wi

387: decode(wi.load_type, WIP_CONSTANTS.CREATE_EAM_JOB, 6, 1),
388: wi.description,
389: wi.primary_item_id,
390: MTL_GEN_OBJECT_ID_S.nextval
391: FROM WIP_JOB_SCHEDULE_INTERFACE wi
392: WHERE wi.rowid = WIP_JSI_Utils.current_rowid ;
393:
394: /* Fix for Bug#3201290 */
395: if ((x_load_type = WIP_CONSTANTS.CREATE_EAM_JOB)

Line 409: wip_job_schedule_interface wi

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;
413:

Line 610: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

606: WDJ.BOM_REVISION_DATE),
607: NVL(WJ.BOM_REVISION,WDJ.BOM_REVISION),
608: DECODE(WJ.LOAD_TYPE, WIP_CONSTANTS.RESCHED_JOB,
609: NVL(WJ.SERIALIZATION_START_OP, WDJ.SERIALIZATION_START_OP), WDJ.SERIALIZATION_START_OP)
610: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
611: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
612: WHERE WDJ.WIP_ENTITY_ID = x_entity_id ;
613:
614: UPDATE WIP_ENTITIES WE

Line 631: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

627: PROGRAM_APPLICATION_ID,
628: PROGRAM_ID,
629: SYSDATE,
630: SYSDATE
631: FROM WIP_JOB_SCHEDULE_INTERFACE WJ
632: WHERE WJ.ROWID = WIP_JSI_Utils.current_rowid)
633: WHERE WE.WIP_ENTITY_ID = x_entity_id ;
634:
635: /* Fix for Bug#3201290 */

Line 816: wip_job_schedule_interface wi

812: bom_bill_of_materials bom,
813: wip_repetitive_items ri,
814: wip_accounting_classes ac,
815: wip_parameters params,
816: wip_job_schedule_interface wi
817: WHERE wi.rowid = WIP_JSI_Utils.current_rowid
818: AND nvl(bor.cfm_routing_flag,2) = 2
819: AND ri.organization_id = wi.organization_id
820: AND ri.primary_item_id = wi.primary_item_id

Line 897: FROM WIP_JOB_SCHEDULE_INTERFACE

893:
894: DELETE FROM WIP_INTERFACE_ERRORS
895: WHERE INTERFACE_ID IN
896: (SELECT INTERFACE_ID
897: FROM WIP_JOB_SCHEDULE_INTERFACE
898: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
899: AND GROUP_ID = P_Group_Id
900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);
901:

Line 902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE

898: WHERE PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
899: AND GROUP_ID = P_Group_Id
900: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE);
901:
902: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE
903: WHERE GROUP_ID = P_Group_Id
904: AND PROCESS_PHASE = WIP_CONSTANTS.ML_COMPLETE
905: AND PROCESS_STATUS = WIP_CONSTANTS.ML_COMPLETE;
906: