APPS.WSM_JOBCOPIES_PUB dependencies on WSM_LOT_BASED_JOBS

Line 481: WSM_LOT_BASED_JOBS WLBJ,

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,
481: WSM_LOT_BASED_JOBS WLBJ,
482: WIP_OPERATION_YIELDS WOY
483: where WO.WIP_ENTITY_ID (+) = WDJ.WIP_ENTITY_ID
484: and WOR.WIP_ENTITY_ID (+) = WO.WIP_ENTITY_ID
485: and WOR.OPERATION_SEQ_NUM (+) = WO.OPERATION_SEQ_NUM

Line 590: update wsm_lot_based_jobs wsm

586: l_stmt_num := 84;
587: -- MES:Populate CURRENT_RTG_OP_SEQ_NUM
588: IF (x_err_code = 0) OR (x_err_code IS NULL) OR (x_err_code = -1) THEN
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)

Line 705: FROM WSM_LOT_BASED_JOBS

701:
702: BEGIN
703: SELECT 1
704: INTO l_temp
705: FROM WSM_LOT_BASED_JOBS
706: WHERE wip_entity_id = cur_refresh_jobs.wip_entity_id;
707:
708: EXCEPTION
709: WHEN NO_DATA_FOUND THEN

Line 711: INSERT into WSM_LOT_BASED_JOBS

707:
708: EXCEPTION
709: WHEN NO_DATA_FOUND THEN
710: l_stmt_num := 130;
711: INSERT into WSM_LOT_BASED_JOBS
712: (WIP_ENTITY_ID,
713: ORGANIZATION_ID,
714: ON_REC_PATH,
715: INTERNAL_COPY_TYPE,