DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 470: from WIP_REQUIREMENT_OPERATIONS WRO,

466: l_stmt_num := 81;
467: -- Explicitly Lock the job details for Bug 12409063.
468: /*
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,

Line 541: from WIP_REQUIREMENT_OPERATIONS WRO

537: and WOR.ORGANIZATION_ID = cur_refresh_jobs.organization_id
538: for update NOWAIT;
539: l_num_tbl.delete;
540: select 1 bulk collect into l_num_tbl
541: from WIP_REQUIREMENT_OPERATIONS WRO
542: where WRO.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
543: and WRO.ORGANIZATION_ID = cur_refresh_jobs.organization_id
544: for update NOWAIT;
545: l_num_tbl.delete;