DBA Data[Home] [Help]

APPS.WIP_FLOW_DERIVE dependencies on MTL_ITEM_LOCATIONS

Line 285: from mtl_item_locations

281: p_item_id => p_item_id,
282: p_hardpeg_only => 2 ) = TRUE ) then
283:
284: select count(*) into l_success
285: from mtl_item_locations
286: where inventory_location_id = p_comp_loc
287: and organization_id = p_org_id
288: and subinventory_code = p_comp_sub ;
289:

Line 402: from mtl_item_locations

398: p_item_id => p_item_id,
399: p_hardpeg_only => 2 ) = TRUE ) then
400:
401: select count(*) into x_success
402: from mtl_item_locations
403: where inventory_location_id = p_comp_loc
404: and organization_id = p_org_id
405: and subinventory_code = p_comp_sub ;
406: