DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SECONDARY_LOCATORS

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