184: AND ORGANIZATION_ID = x_organization_id;
185: /* check mfg_lookups for lookup_type = 'RESTRICT_LOCATORS_CODE' */
186:
187: /* if an item under restricted loc control, locator must be defined
188: ** in mtl_secondary_locators.
189: */
190: IF x_restrict_loc = 1 THEN
191: x_progress := '030';
192: SELECT 'restrict_ok'
190: IF x_restrict_loc = 1 THEN
191: x_progress := '030';
192: SELECT 'restrict_ok'
193: INTO x_status
194: FROM MTL_SECONDARY_LOCATORS
195: WHERE INVENTORY_ITEM_ID = x_item_id
196: AND ORGANIZATION_ID = x_organization_id
197: AND SECONDARY_LOCATOR = x_locator;
198: