APPS.BOM_RTG_OI_UTIL dependencies on WIP_LINES

Line 233: FROM WIP_LINES wl1

229: stmt_num := 8 ;
230: /* Update the line code from line_id */
231: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
232: SET line_code = (SELECT line_code
233: FROM WIP_LINES wl1
234: WHERE wl1.LINE_ID = BORI.LINE_ID -- Bug Fix 3782414
235: AND wl1.organization_id = BORI.organization_id)
236: WHERE process_flag = 1
237: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 246: FROM WIP_LINES wl2

242: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
243: OR ( p_batch_id = BORI.batch_id )
244: )
245: AND exists (SELECT 'x'
246: FROM WIP_LINES wl2
247: WHERE wl2.organization_id = BORI.organization_id
248: AND nvl(wl2.disable_date, trunc(sysdate) + 1) > trunc(sysdate));
249:
250: stmt_num := 9;