DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 4026: FROM WIP_JOB_SCHEDULE_INTERFACE

4022: --
4023: DELETE FROM WIP_INTERFACE_ERRORS
4024: WHERE INTERFACE_ID IN (
4025: SELECT INTERFACE_ID
4026: FROM WIP_JOB_SCHEDULE_INTERFACE
4027: WHERE source_line_id = to_number(p_itemkey)
4028: AND PROCESS_PHASE = 4
4029: AND PROCESS_STATUS = 4);
4030:

Line 4038: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I

4034: oe_debug_pub.add ('submit_conc_prog_wf: ' || 'Rows deleted from wie:' || l_cnt);
4035: end if;
4036: END IF;
4037:
4038: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I
4039: WHERE source_line_id = to_number(p_itemkey)
4040: AND I.PROCESS_PHASE = 4
4041: AND I.PROCESS_STATUS = 4;
4042: