APPS.WSH_DEL_OI_CORE dependencies on MTL_SECONDARY_LOCATORS

Line 441: from mtl_secondary_locators mtlsls

437: or
438: (nvl(X_location_restricted_flag, 'N') = 'Y'
439: and nvl(mtlloc.inventory_location_id, -1) in (
440: select mtlsls.secondary_locator
441: from mtl_secondary_locators mtlsls
442: where mtlsls.organization_id = X_warehouse_id
443: and mtlsls.inventory_item_id = X_item_id
444: and mtlsls.subinventory_code = X_subinventory)));
445: begin

Line 508: from mtl_secondary_locators mtlsls

504: OR
505: (nvl(X_location_restricted_flag, 'N') = 'Y'
506: and nvl(mtldl.locator_id, -1) in
507: (select mtlsls.secondary_locator
508: from mtl_secondary_locators mtlsls
509: where mtlsls.organization_id = X_warehouse_id
510: and mtlsls.inventory_item_id = X_item_id
511: and mtlsls.subinventory_code = X_subinventory)));
512: dflt_locator_id number;

Line 585: FROM MTL_SECONDARY_LOCATORS MTLSLS

581: (NVL(x_location_restricted_flag, 'N') = 'Y'
582: AND
583: NVL(LOC.INVENTORY_LOCATION_ID, -1) IN (
584: SELECT NVL(MAX(MTLSLS.SECONDARY_LOCATOR),-1)
585: FROM MTL_SECONDARY_LOCATORS MTLSLS
586: WHERE MTLSLS.ORGANIZATION_ID = x_warehouse_id
587: AND MTLSLS.INVENTORY_ITEM_ID = x_item_id
588: AND MTLSLS.SUBINVENTORY_CODE = x_subinventory
589: -- Bug 842175