APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 696: FROM mtl_secondary_inventories

692: -- bug 2398247
693: -- verify if sub is active
694: SELECT COUNT(*)
695: INTO l_sub_active
696: FROM mtl_secondary_inventories
697: WHERE Nvl(disable_date, Sysdate+1) > Sysdate
698: AND organization_id = p_org_id
699: AND secondary_inventory_name = l_sub;
700:

Line 2811: mtl_secondary_inventories msi

2807: msi.lpn_controlled_flag
2808: INTO
2809: l_lpn_controlled_flag
2810: FROM
2811: mtl_secondary_inventories msi
2812: WHERE msi.organization_id = l_rec.organization_id
2813: AND msi.secondary_inventory_name = l_rec.transfer_sub_code
2814: AND sysdate <= nvl(msi.disable_date,sysdate);
2815: EXCEPTION