APPS.WSM_JOBCOPIES_PUB dependencies on WIP_OPERATION_RESOURCES

Line 473: WIP_OPERATION_RESOURCES WOR,

469: select 1 bulk collect into l_num_tbl
470: from WIP_REQUIREMENT_OPERATIONS WRO,
471: WIP_OPERATION_RESOURCE_USAGE WORU,
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,

Line 504: from WIP_OPERATION_RESOURCES WOR,

500: for update NOWAIT;
501: */
502:
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

Line 535: from WIP_OPERATION_RESOURCES WOR

531: and WO.ORGANIZATION_ID = cur_refresh_jobs.organization_id
532: for update NOWAIT;
533: l_num_tbl.delete;
534: select 1 bulk collect into l_num_tbl
535: from WIP_OPERATION_RESOURCES WOR
536: where WOR.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
537: and WOR.ORGANIZATION_ID = cur_refresh_jobs.organization_id
538: for update NOWAIT;
539: l_num_tbl.delete;