APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_ITEM_LOCATIONS

Line 1365: FROM mtl_item_locations

1361: --END IF;
1362:
1363: SELECT status_id
1364: INTO g_isa_loc_status_id
1365: FROM mtl_item_locations
1366: WHERE inventory_location_id = p_locator_id
1367: AND organization_id = p_organization_id;
1368:
1369: g_isa_organization_id := p_organization_id;

Line 2123: FROM mtl_item_locations a, mtl_secondary_locators b

2119: RETURN 'Y';
2120: ELSE
2121: SELECT count(*)
2122: INTO l_temp
2123: FROM mtl_item_locations a, mtl_secondary_locators b
2124: WHERE b.organization_id = p_org_id
2125: AND b.inventory_item_id = p_inventory_item_id
2126: AND b.subinventory_code = p_sub_code
2127: AND a.inventory_location_id = b.secondary_locator