APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_ITEM_LOCATIONS

Line 1228: from mtl_item_locations

1224: -- then retrieve status_id from MOQD.
1225: if (l_default_status_id is null) then
1226: select status_id
1227: into g_isa_loc_status_id
1228: from mtl_item_locations
1229: where inventory_location_id = p_locator_id
1230: and organization_id = p_organization_id;
1231:
1232: g_isa_organization_id := p_organization_id;

Line 1735: FROM mtl_item_locations a, mtl_secondary_locators b

1731: RETURN 'Y';
1732: ELSE
1733: SELECT count(*)
1734: INTO l_temp
1735: FROM mtl_item_locations a, mtl_secondary_locators b
1736: WHERE b.organization_id = p_org_id
1737: AND b.inventory_item_id = p_inventory_item_id
1738: AND b.subinventory_code = p_sub_code
1739: AND a.inventory_location_id = b.secondary_locator