APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 1215: FROM mtl_secondary_inventories

1211: -- bug 2398247
1212: -- verify if sub is active
1213: SELECT COUNT(*)
1214: INTO l_sub_active
1215: FROM mtl_secondary_inventories
1216: WHERE Nvl(disable_date, Sysdate+1) > Sysdate
1217: AND organization_id = p_org_id
1218: AND secondary_inventory_name = l_sub;
1219:

Line 3356: mtl_secondary_inventories msi

3352: msi.lpn_controlled_flag
3353: INTO
3354: l_lpn_controlled_flag
3355: FROM
3356: mtl_secondary_inventories msi
3357: WHERE msi.organization_id = l_rec.organization_id
3358: AND msi.secondary_inventory_name = l_rec.transfer_sub_code
3359: AND sysdate <= nvl(msi.disable_date,sysdate);
3360: EXCEPTION