APPS.WSMPJUPD dependencies on WSM_SECONDARY_UOMS

Line 339: from wsm_secondary_uoms

335: set currently_active =2,
336: current_quantity=null
337: where wip_entity_id = l_sj_rj_wip_entity_id
338: AND uom_code not in (select uom_code
339: from wsm_secondary_uoms
340: where inventory_item_id =l_sj_rj_inventory_item_id);
341:
342: if( g_log_level_statement >= l_log_level ) then
343: l_msg_tokens.delete;

Line 362: from wsm_secondary_uoms

358: set currently_active = 1,
359: current_quantity= null
360: where wip_entity_id = l_sj_rj_wip_entity_id
361: AND uom_code in (select uom_code
362: from wsm_secondary_uoms
363: where inventory_item_id =l_sj_rj_inventory_item_id)
364: AND currently_active = 2; --Bugfix 4765660, left out of fix for 5046332
365:
366: if( g_log_level_statement >= l_log_level ) then

Line 378: --Insert new UOMs skeletal info into the base table by reading from wsm_secondary_uoms

374: );
375: End if;
376: -- ST : Bug fix 5046332 : End --
377:
378: --Insert new UOMs skeletal info into the base table by reading from wsm_secondary_uoms
379: insert into wsm_job_secondary_quantities
380: (wip_entity_id
381: ,organization_id
382: ,uom_code

Line 404: from wsm_secondary_uoms

400: fnd_global.user_id,
401: fnd_global.login_id,
402: sysdate,
403: fnd_global.user_id
404: from wsm_secondary_uoms
405: where inventory_item_id = l_sj_rj_inventory_item_id -- (resulting job's item id..)
406: -- ST : Bug Fix 5046332 : Commenting out the below condition ---
407: -- and uom_code not in (select uom_code
408: -- from wsm_secondary_uoms

Line 408: -- from wsm_secondary_uoms

404: from wsm_secondary_uoms
405: where inventory_item_id = l_sj_rj_inventory_item_id -- (resulting job's item id..)
406: -- ST : Bug Fix 5046332 : Commenting out the below condition ---
407: -- and uom_code not in (select uom_code
408: -- from wsm_secondary_uoms
409: -- where inventory_item_id= p_wltx_starting_jobs_tbl(p_rep_job_index).primary_item_id)
410: -- -- ST : Sec. UOM Fix : Use the starting rep jobs's item id --
411: -- ST : Bug Fix 5046332 : Added the below condition ---
412: and uom_code not in (select uom_code

Line 609: from wsm_secondary_uoms

605: fnd_global.user_id,
606: fnd_global.login_id,
607: sysdate,
608: fnd_global.user_id
609: from wsm_secondary_uoms
610: where inventory_item_id = p_wltx_resulting_jobs_tbl(l_counter).primary_item_id
611: );
612:
613: if( g_log_level_statement >= l_log_level ) then