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 10370: p_msg_text => 'B4 UPDATE WIP_OPERATION_YIELDS woy '

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

Line 10387: UPDATE WIP_OPERATION_YIELDS woy

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

Line 10398: WIP_OPERATION_YIELDS woy2,

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

Line 10486: WIP_OPERATION_YIELDS woy2,

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

Line 10576: UPDATE WIP_OPERATION_YIELDS woy

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

Line 10587: WIP_OPERATION_YIELDS woy2,

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