DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on MTL_SECONDARY_LOCATORS

Line 188: ** in mtl_secondary_locators.

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'

Line 194: FROM MTL_SECONDARY_LOCATORS

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: