DBA Data[Home] [Help]

APPS.WIP_FLOW_DERIVE dependencies on MTL_ITEM_LOCATIONS

Line 278: from mtl_item_locations

274: p_item_id => p_item_id,
275: p_hardpeg_only => 2 ) = TRUE ) then
276:
277: select count(*) into l_success
278: from mtl_item_locations
279: where inventory_location_id = p_comp_loc
280: and organization_id = p_org_id
281: and subinventory_code = p_comp_sub ;
282:

Line 393: from mtl_item_locations

389: p_item_id => p_item_id,
390: p_hardpeg_only => 2 ) = TRUE ) then
391:
392: select count(*) into x_success
393: from mtl_item_locations
394: where inventory_location_id = p_comp_loc
395: and organization_id = p_org_id
396: and subinventory_code = p_comp_sub ;
397: