APPS.WSMPLBMI dependencies on WIP_OPERATION_YIELDS

Line 4289: UPDATE WIP_OPERATION_YIELDS WOY

4285: return(x_return_code);
4286: end if;
4287: end if;
4288:
4289: UPDATE WIP_OPERATION_YIELDS WOY
4290: SET SCRAP_ACCOUNT = nvl(l_scrap_account, WOY.SCRAP_ACCOUNT),
4291: EST_SCRAP_ABSORB_ACCOUNT = nvl(l_est_scrap_abs_account, WOY.EST_SCRAP_ABSORB_ACCOUNT)
4292: WHERE WIP_ENTITY_ID = l_wip_entity_id
4293: --** VJ: Start Changes for removal of 9999 **--

Line 10372: p_msg_text => 'B4 UPDATE WIP_OPERATION_YIELDS woy '

10368: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
10369: l_msg_tokens.delete;
10370: WSM_log_PVT.logMessage (
10371: p_module_name => l_module,
10372: p_msg_text => 'B4 UPDATE WIP_OPERATION_YIELDS woy '
10373: ||';p_group_id '
10374: ||p_group_id
10375: ||';l_wmti_group_id '
10376: ||l_wmti_group_id ,

Line 10389: UPDATE WIP_OPERATION_YIELDS woy

10385:
10386: /* Bug Fix 5969857. Use UNION ALL for wmt.transaction_id instead of wmt.transaction_id in
10387: (wlmti.transaction_id, wlmti.internal_scrap_txn_id)*/
10388:
10389: UPDATE WIP_OPERATION_YIELDS woy
10390: SET status = 1,
10391: last_update_date = sysdate,
10392: last_update_login = g_login_id,
10393: request_id = g_request_id,

Line 10400: WIP_OPERATION_YIELDS woy2,

10396: program_update_date = DECODE(g_request_id,NULL,NULL,SYSDATE)
10397: WHERE woy.rowid IN ((
10398: SELECT woy2.rowid
10399: FROM WIP_OPERATIONS wop2,
10400: WIP_OPERATION_YIELDS woy2,
10401: WSM_PARAMETERS wp, -- ESA
10402: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10403: WIP_MOVE_TRANSACTIONS wmt,
10404: WSM_LOT_MOVE_TXN_INTERFACE wlmti

Line 10488: WIP_OPERATION_YIELDS woy2,

10484: UNION ALL
10485: (
10486: SELECT woy2.rowid
10487: FROM WIP_OPERATIONS wop2,
10488: WIP_OPERATION_YIELDS woy2,
10489: WSM_PARAMETERS wp, -- ESA
10490: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10491: WIP_MOVE_TRANSACTIONS wmt,
10492: WSM_LOT_MOVE_TXN_INTERFACE wlmti

Line 10578: UPDATE WIP_OPERATION_YIELDS woy

10574: fnd_file.put_line(fnd_file.log, 'WSMPLBMI.MoveTransaction' ||'(stmt_num='||l_stmt_num||') :
10575: Updated '||SQL%ROWCOUNT||' rows in WOY');
10576: END IF;
10577: /**********************************
10578: UPDATE WIP_OPERATION_YIELDS woy
10579: SET status = 1,
10580: last_update_date = sysdate,
10581: last_update_login = g_login_id,
10582: request_id = g_request_id,

Line 10589: WIP_OPERATION_YIELDS woy2,

10585: program_update_date = DECODE(g_request_id,NULL,NULL,SYSDATE)
10586: WHERE woy.rowid IN (
10587: SELECT woy2.rowid
10588: FROM WIP_OPERATIONS wop2,
10589: WIP_OPERATION_YIELDS woy2,
10590: WSM_PARAMETERS wp, -- ESA
10591: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10592: WIP_MOVE_TXN_INTERFACE wti
10593: WHERE wti.group_id = l_wmti_group_id