APPS.WSM_JOBCOPIES_PUB dependencies on WSM_COPY_OPERATIONS

Line 476: WSM_COPY_OPERATIONS WCO,

472: WIP_SUB_OPERATION_RESOURCES WSOR,
473: WIP_OPERATION_RESOURCES WOR,
474: WIP_OPERATIONS WO,
475: WIP_DISCRETE_JOBS WDJ,
476: WSM_COPY_OPERATIONS WCO,
477: WSM_COPY_OP_NETWORKS WCON,
478: WSM_COPY_OP_RESOURCES WCOR,
479: WSM_COPY_OP_RESOURCE_USAGE WCORU,
480: WSM_COPY_REQUIREMENT_OPS WCRO,

Line 507: WSM_COPY_OPERATIONS WCO,

503: /* select 1 bulk collect into l_num_tbl
504: from WIP_OPERATION_RESOURCES WOR,
505: WIP_OPERATIONS WO,
506: WIP_DISCRETE_JOBS WDJ,
507: WSM_COPY_OPERATIONS WCO,
508: WSM_COPY_OP_RESOURCES WCOR
509: where WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
510: and WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
511: and WOR.WIP_ENTITY_ID (+) = WDJ.WIP_ENTITY_ID

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

589:
590: update wsm_lot_based_jobs wsm
591: set wsm.current_rtg_op_seq_num = null
592: where wsm.wip_entity_id = cur_refresh_jobs.wip_entity_id
593: and not exists (select 1 from wsm_copy_operations wco
594: where wco.operation_seq_num = nvl(wsm.current_job_op_seq_num,-1)
595: and wco.wip_entity_id = cur_refresh_jobs.wip_entity_id);
596: -- END IF;
597: --*************************************************************************************************************