DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PUB dependencies on WIP_OPERATIONS

Line 474: WIP_OPERATIONS WO,

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,
478: WSM_COPY_OP_RESOURCES WCOR,

Line 505: WIP_OPERATIONS WO,

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
509: where WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID

Line 529: from WIP_OPERATIONS WO

525: and WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
526: for update NOWAIT;
527: l_num_tbl.delete;
528: select 1 bulk collect into l_num_tbl
529: from WIP_OPERATIONS WO
530: where WO.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
531: and WO.ORGANIZATION_ID = cur_refresh_jobs.organization_id
532: for update NOWAIT;
533: l_num_tbl.delete;