APPS.WSM_JOBCOPIES_PUB dependencies on WSM_COPY_OPERATIONS

Line 535: and not in (select wco.operation_seq_id from wsm_copy_operations wco

531: set wo.operation_seq_id = NULL,
532: wo.wsm_copy_op_seq_num = NULL
533: where wo.operation_seq_id is NOT NULL
534: and wo.wip_entity_id = cur_refresh_jobs.wip_entity_id
535: and not in (select wco.operation_seq_id from wsm_copy_operations wco
536: where wco.operation_seq_id = nvl(wo.operation_seq_id,-1)
537: and wco.wip_entity_id = cur_refresh_jobs.wip_entity_id);
538: IF SQL%ROWCOUNT > 0 THEN */
539: update wsm_lot_based_jobs wsm

Line 542: and not exists (select 1 from wsm_copy_operations wco

538: IF SQL%ROWCOUNT > 0 THEN */
539: update wsm_lot_based_jobs wsm
540: set wsm.current_rtg_op_seq_num = null
541: where wsm.wip_entity_id = cur_refresh_jobs.wip_entity_id
542: and not exists (select 1 from wsm_copy_operations wco
543: where wco.operation_seq_num = nvl(wsm.current_job_op_seq_num,-1)
544: and wco.wip_entity_id = cur_refresh_jobs.wip_entity_id);
545: -- END IF;
546: --*************************************************************************************************************