APPS.WSH_DEL_OI_CORE dependencies on MTL_ITEM_LOCATIONS

Line 433: from mtl_item_locations mtlloc

429: declare
430: sql_string varchar2(30);
431: cursor validate_locator is
432: select 'valid locator id'
433: from mtl_item_locations mtlloc
434: where organization_id = X_warehouse_id
435: and mtlloc.inventory_location_id = X_locator_id
436: and ( nvl(X_location_restricted_flag, 'N') = 'N'
437: or

Line 561: MTL_ITEM_LOCATIONS LOC

557: cursor validate_ser_num is
558: SELECT
559: 'valid serial number', S.CURRENT_STATUS
560: FROM MTL_SERIAL_NUMBERS S,
561: MTL_ITEM_LOCATIONS LOC
562: WHERE S.CURRENT_ORGANIZATION_ID = x_warehouse_id
563: AND S.INVENTORY_ITEM_ID = x_item_id
564: AND NVL( S.REVISION, '~' ) = NVL( x_revision, '~' )
565: AND NVL( S.LOT_NUMBER, '~' ) = NVL( x_lot_number, '~' )