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 611: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

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

Line 632: FROM WIP_JOB_SCHEDULE_INTERFACE WJ

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

Line 817: wip_job_schedule_interface wi

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

Line 898: FROM WIP_JOB_SCHEDULE_INTERFACE

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

Line 903: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE

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