DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on MTL_ITEM_LOCATIONS

Line 2275: from mtl_parameters mp, mtl_item_locations_kfv milk

2271: null,milk.concatenated_segments,
2272: 2,milk.concatenated_segments,
2273: 1, inv_project.get_pjm_locsegs(milk.concatenated_segments))
2274: into x_compTbl(l_count).locator_name
2275: from mtl_parameters mp, mtl_item_locations_kfv milk
2276: where mp.organization_id = p_orgID
2277: and mp.organization_id = milk.organization_id
2278: and milk.inventory_location_id = x_compTbl(l_count).supply_locator_id;
2279: end if;

Line 2798: from mtl_item_locations

2794: set (locator_id, project_id, task_id) =
2795: (select inventory_location_id,
2796: project_id,
2797: task_id
2798: from mtl_item_locations
2799: where inventory_location_id = comp_rec.locator_id
2800: and organization_id = l_orgID)
2801: where rowid = comp_rec.rowid;
2802: end if;